{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "test_notebook_model_deployment_azure_gcp_regression.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "include_colab_link": true
    },
    "kernelspec": {
      "display_name": "Python 3",
      "language": "python",
      "name": "python3"
    },
    "language_info": {
      "codemirror_mode": {
        "name": "ipython",
        "version": 3
      },
      "file_extension": ".py",
      "mimetype": "text/x-python",
      "name": "python",
      "nbconvert_exporter": "python",
      "pygments_lexer": "ipython3",
      "version": "3.7.4"
    },
    "widgets": {
      "application/vnd.jupyter.widget-state+json": {
        "efaff962f0a94c8d8f5d06311e023506": {
          "model_module": "@jupyter-widgets/controls",
          "model_name": "IntProgressModel",
          "state": {
            "_view_name": "ProgressView",
            "style": "IPY_MODEL_c2e2060613d444078b48b60e30a112e7",
            "_dom_classes": [],
            "description": "Processing: ",
            "_model_name": "IntProgressModel",
            "bar_style": "",
            "max": 13,
            "_view_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "value": 3,
            "_view_count": null,
            "_view_module_version": "1.5.0",
            "orientation": "horizontal",
            "min": 0,
            "description_tooltip": null,
            "_model_module": "@jupyter-widgets/controls",
            "layout": "IPY_MODEL_09690916f8634c01b8b289d83119e178"
          }
        },
        "c2e2060613d444078b48b60e30a112e7": {
          "model_module": "@jupyter-widgets/controls",
          "model_name": "ProgressStyleModel",
          "state": {
            "_view_name": "StyleView",
            "_model_name": "ProgressStyleModel",
            "description_width": "",
            "_view_module": "@jupyter-widgets/base",
            "_model_module_version": "1.5.0",
            "_view_count": null,
            "_view_module_version": "1.2.0",
            "bar_color": null,
            "_model_module": "@jupyter-widgets/controls"
          }
        },
        "09690916f8634c01b8b289d83119e178": {
          "model_module": "@jupyter-widgets/base",
          "model_name": "LayoutModel",
          "state": {
            "_view_name": "LayoutView",
            "grid_template_rows": null,
            "right": null,
            "justify_content": null,
            "_view_module": "@jupyter-widgets/base",
            "overflow": null,
            "_model_module_version": "1.2.0",
            "_view_count": null,
            "flex_flow": null,
            "width": null,
            "min_width": null,
            "border": null,
            "align_items": null,
            "bottom": null,
            "_model_module": "@jupyter-widgets/base",
            "top": null,
            "grid_column": null,
            "overflow_y": null,
            "overflow_x": null,
            "grid_auto_flow": null,
            "grid_area": null,
            "grid_template_columns": null,
            "flex": null,
            "_model_name": "LayoutModel",
            "justify_items": null,
            "grid_row": null,
            "max_height": null,
            "align_content": null,
            "visibility": null,
            "align_self": null,
            "height": null,
            "min_height": null,
            "padding": null,
            "grid_auto_rows": null,
            "grid_gap": null,
            "max_width": null,
            "order": null,
            "_view_module_version": "1.2.0",
            "grid_template_areas": null,
            "object_position": null,
            "object_fit": null,
            "grid_auto_columns": null,
            "margin": null,
            "display": null,
            "left": null
          }
        },
        "dbb0c8ed8d2f4b37a492d777d1cfcd48": {
          "model_module": "@jupyter-widgets/controls",
          "model_name": "TextModel",
          "state": {
            "_view_name": "TextView",
            "style": "IPY_MODEL_5db0cd1626b044b6ada0e461e2d7c94b",
            "_dom_classes": [],
            "description": "",
            "_model_name": "TextModel",
            "placeholder": "​",
            "_view_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "value": "Following data types have been inferred automatically, if they are correct press enter to continue or type 'quit' otherwise.",
            "_view_count": null,
            "disabled": false,
            "_view_module_version": "1.5.0",
            "continuous_update": true,
            "description_tooltip": null,
            "_model_module": "@jupyter-widgets/controls",
            "layout": "IPY_MODEL_8a5e8367e06b49dcbe1550b7ce9a8380"
          }
        },
        "5db0cd1626b044b6ada0e461e2d7c94b": {
          "model_module": "@jupyter-widgets/controls",
          "model_name": "DescriptionStyleModel",
          "state": {
            "_view_name": "StyleView",
            "_model_name": "DescriptionStyleModel",
            "description_width": "",
            "_view_module": "@jupyter-widgets/base",
            "_model_module_version": "1.5.0",
            "_view_count": null,
            "_view_module_version": "1.2.0",
            "_model_module": "@jupyter-widgets/controls"
          }
        },
        "8a5e8367e06b49dcbe1550b7ce9a8380": {
          "model_module": "@jupyter-widgets/base",
          "model_name": "LayoutModel",
          "state": {
            "_view_name": "LayoutView",
            "grid_template_rows": null,
            "right": null,
            "justify_content": null,
            "_view_module": "@jupyter-widgets/base",
            "overflow": null,
            "_model_module_version": "1.2.0",
            "_view_count": null,
            "flex_flow": null,
            "width": "100%",
            "min_width": null,
            "border": null,
            "align_items": null,
            "bottom": null,
            "_model_module": "@jupyter-widgets/base",
            "top": null,
            "grid_column": null,
            "overflow_y": null,
            "overflow_x": null,
            "grid_auto_flow": null,
            "grid_area": null,
            "grid_template_columns": null,
            "flex": null,
            "_model_name": "LayoutModel",
            "justify_items": null,
            "grid_row": null,
            "max_height": null,
            "align_content": null,
            "visibility": null,
            "align_self": null,
            "height": null,
            "min_height": null,
            "padding": null,
            "grid_auto_rows": null,
            "grid_gap": null,
            "max_width": null,
            "order": null,
            "_view_module_version": "1.2.0",
            "grid_template_areas": null,
            "object_position": null,
            "object_fit": null,
            "grid_auto_columns": null,
            "margin": null,
            "display": null,
            "left": null
          }
        },
        "f82b0cd6d54b427ea21cf2a5b2958c21": {
          "model_module": "@jupyter-widgets/controls",
          "model_name": "IntProgressModel",
          "state": {
            "_view_name": "ProgressView",
            "style": "IPY_MODEL_0f57ccbc1ce543ad9b7d837c7fe03595",
            "_dom_classes": [],
            "description": "Processing: ",
            "_model_name": "IntProgressModel",
            "bar_style": "",
            "max": 14,
            "_view_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "value": 14,
            "_view_count": null,
            "_view_module_version": "1.5.0",
            "orientation": "horizontal",
            "min": 0,
            "description_tooltip": null,
            "_model_module": "@jupyter-widgets/controls",
            "layout": "IPY_MODEL_2dae5a1a055343ea88a268f14cc53a49"
          }
        },
        "0f57ccbc1ce543ad9b7d837c7fe03595": {
          "model_module": "@jupyter-widgets/controls",
          "model_name": "ProgressStyleModel",
          "state": {
            "_view_name": "StyleView",
            "_model_name": "ProgressStyleModel",
            "description_width": "",
            "_view_module": "@jupyter-widgets/base",
            "_model_module_version": "1.5.0",
            "_view_count": null,
            "_view_module_version": "1.2.0",
            "bar_color": null,
            "_model_module": "@jupyter-widgets/controls"
          }
        },
        "2dae5a1a055343ea88a268f14cc53a49": {
          "model_module": "@jupyter-widgets/base",
          "model_name": "LayoutModel",
          "state": {
            "_view_name": "LayoutView",
            "grid_template_rows": null,
            "right": null,
            "justify_content": null,
            "_view_module": "@jupyter-widgets/base",
            "overflow": null,
            "_model_module_version": "1.2.0",
            "_view_count": null,
            "flex_flow": null,
            "width": null,
            "min_width": null,
            "border": null,
            "align_items": null,
            "bottom": null,
            "_model_module": "@jupyter-widgets/base",
            "top": null,
            "grid_column": null,
            "overflow_y": null,
            "overflow_x": null,
            "grid_auto_flow": null,
            "grid_area": null,
            "grid_template_columns": null,
            "flex": null,
            "_model_name": "LayoutModel",
            "justify_items": null,
            "grid_row": null,
            "max_height": null,
            "align_content": null,
            "visibility": null,
            "align_self": null,
            "height": null,
            "min_height": null,
            "padding": null,
            "grid_auto_rows": null,
            "grid_gap": null,
            "max_width": null,
            "order": null,
            "_view_module_version": "1.2.0",
            "grid_template_areas": null,
            "object_position": null,
            "object_fit": null,
            "grid_auto_columns": null,
            "margin": null,
            "display": null,
            "left": null
          }
        },
        "1de1da0d08c64148935f305cafdeaadc": {
          "model_module": "@jupyter-widgets/controls",
          "model_name": "IntProgressModel",
          "state": {
            "_view_name": "ProgressView",
            "style": "IPY_MODEL_577eb34fbd6f4bdea66489337463c354",
            "_dom_classes": [],
            "description": "Processing: ",
            "_model_name": "IntProgressModel",
            "bar_style": "",
            "max": 16,
            "_view_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "value": 16,
            "_view_count": null,
            "_view_module_version": "1.5.0",
            "orientation": "horizontal",
            "min": 0,
            "description_tooltip": null,
            "_model_module": "@jupyter-widgets/controls",
            "layout": "IPY_MODEL_f9312a23e9af43e183ebd777b133a2a9"
          }
        },
        "577eb34fbd6f4bdea66489337463c354": {
          "model_module": "@jupyter-widgets/controls",
          "model_name": "ProgressStyleModel",
          "state": {
            "_view_name": "StyleView",
            "_model_name": "ProgressStyleModel",
            "description_width": "",
            "_view_module": "@jupyter-widgets/base",
            "_model_module_version": "1.5.0",
            "_view_count": null,
            "_view_module_version": "1.2.0",
            "bar_color": null,
            "_model_module": "@jupyter-widgets/controls"
          }
        },
        "f9312a23e9af43e183ebd777b133a2a9": {
          "model_module": "@jupyter-widgets/base",
          "model_name": "LayoutModel",
          "state": {
            "_view_name": "LayoutView",
            "grid_template_rows": null,
            "right": null,
            "justify_content": null,
            "_view_module": "@jupyter-widgets/base",
            "overflow": null,
            "_model_module_version": "1.2.0",
            "_view_count": null,
            "flex_flow": null,
            "width": null,
            "min_width": null,
            "border": null,
            "align_items": null,
            "bottom": null,
            "_model_module": "@jupyter-widgets/base",
            "top": null,
            "grid_column": null,
            "overflow_y": null,
            "overflow_x": null,
            "grid_auto_flow": null,
            "grid_area": null,
            "grid_template_columns": null,
            "flex": null,
            "_model_name": "LayoutModel",
            "justify_items": null,
            "grid_row": null,
            "max_height": null,
            "align_content": null,
            "visibility": null,
            "align_self": null,
            "height": null,
            "min_height": null,
            "padding": null,
            "grid_auto_rows": null,
            "grid_gap": null,
            "max_width": null,
            "order": null,
            "_view_module_version": "1.2.0",
            "grid_template_areas": null,
            "object_position": null,
            "object_fit": null,
            "grid_auto_columns": null,
            "margin": null,
            "display": null,
            "left": null
          }
        }
      }
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/amjadraza/pycaret/blob/feature%2Fgcp_azure_np_docs/examples/test_notebook_model_deployment_azure_gcp_regression.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "LrRweUsz9bSl",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "572e1550-2c0b-4a99-ed67-1d6de4f40a52"
      },
      "source": [
        "! pip uninstall pycaret\n",
        "!pip install git+https://github.com/amjadraza/pycaret.git@feature/gcp_azure_np_docs"
      ],
      "execution_count": 1,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "\u001b[33mWARNING: Skipping pycaret as it is not installed.\u001b[0m\n",
            "Collecting git+https://github.com/amjadraza/pycaret.git@feature/gcp_azure_np_docs\n",
            "  Cloning https://github.com/amjadraza/pycaret.git (to revision feature/gcp_azure_np_docs) to /tmp/pip-req-build-2ast6ys_\n",
            "  Running command git clone -q https://github.com/amjadraza/pycaret.git /tmp/pip-req-build-2ast6ys_\n",
            "  Running command git checkout -b feature/gcp_azure_np_docs --track origin/feature/gcp_azure_np_docs\n",
            "  Switched to a new branch 'feature/gcp_azure_np_docs'\n",
            "  Branch 'feature/gcp_azure_np_docs' set up to track remote branch 'feature/gcp_azure_np_docs' from 'origin'.\n",
            "Requirement already satisfied: pandas in /usr/local/lib/python3.6/dist-packages (from pycaret==2.0) (1.0.5)\n",
            "Requirement already satisfied: numpy>=1.17 in /usr/local/lib/python3.6/dist-packages (from pycaret==2.0) (1.18.5)\n",
            "Requirement already satisfied: seaborn in /usr/local/lib/python3.6/dist-packages (from pycaret==2.0) (0.10.1)\n",
            "Requirement already satisfied: matplotlib in /usr/local/lib/python3.6/dist-packages (from pycaret==2.0) (3.2.2)\n",
            "Requirement already satisfied: IPython in /usr/local/lib/python3.6/dist-packages (from pycaret==2.0) (5.5.0)\n",
            "Requirement already satisfied: joblib in /usr/local/lib/python3.6/dist-packages (from pycaret==2.0) (0.16.0)\n",
            "Collecting scikit-learn>=0.23\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/5c/a1/273def87037a7fb010512bbc5901c31cfddfca8080bc63b42b26e3cc55b3/scikit_learn-0.23.2-cp36-cp36m-manylinux1_x86_64.whl (6.8MB)\n",
            "\u001b[K     |████████████████████████████████| 6.8MB 7.2MB/s \n",
            "\u001b[?25hRequirement already satisfied: ipywidgets in /usr/local/lib/python3.6/dist-packages (from pycaret==2.0) (7.5.1)\n",
            "Collecting yellowbrick>=1.0.1\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/13/95/a14e4fdfb8b1c8753bbe74a626e910a98219ef9c87c6763585bbd30d84cf/yellowbrick-1.1-py3-none-any.whl (263kB)\n",
            "\u001b[K     |████████████████████████████████| 266kB 42.3MB/s \n",
            "\u001b[?25hRequirement already satisfied: xgboost>=0.90 in /usr/local/lib/python3.6/dist-packages (from pycaret==2.0) (0.90)\n",
            "Collecting lightgbm>=2.3.1\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/0b/9d/ddcb2f43aca194987f1a99e27edf41cf9bc39ea750c3371c2a62698c509a/lightgbm-2.3.1-py2.py3-none-manylinux1_x86_64.whl (1.2MB)\n",
            "\u001b[K     |████████████████████████████████| 1.2MB 42.8MB/s \n",
            "\u001b[?25hRequirement already satisfied: plotly>=4.4.1 in /usr/local/lib/python3.6/dist-packages (from pycaret==2.0) (4.4.1)\n",
            "Requirement already satisfied: wordcloud in /usr/local/lib/python3.6/dist-packages (from pycaret==2.0) (1.5.0)\n",
            "Requirement already satisfied: textblob in /usr/local/lib/python3.6/dist-packages (from pycaret==2.0) (0.15.3)\n",
            "Requirement already satisfied: cufflinks>=0.17.0 in /usr/local/lib/python3.6/dist-packages (from pycaret==2.0) (0.17.3)\n",
            "Requirement already satisfied: umap-learn in /usr/local/lib/python3.6/dist-packages (from pycaret==2.0) (0.4.6)\n",
            "Collecting pyLDAvis\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/a5/3a/af82e070a8a96e13217c8f362f9a73e82d61ac8fff3a2561946a97f96266/pyLDAvis-2.1.2.tar.gz (1.6MB)\n",
            "\u001b[K     |████████████████████████████████| 1.6MB 44.2MB/s \n",
            "\u001b[?25hRequirement already satisfied: gensim in /usr/local/lib/python3.6/dist-packages (from pycaret==2.0) (3.6.0)\n",
            "Requirement already satisfied: spacy in /usr/local/lib/python3.6/dist-packages (from pycaret==2.0) (2.2.4)\n",
            "Requirement already satisfied: nltk in /usr/local/lib/python3.6/dist-packages (from pycaret==2.0) (3.2.5)\n",
            "Requirement already satisfied: mlxtend in /usr/local/lib/python3.6/dist-packages (from pycaret==2.0) (0.14.0)\n",
            "Collecting pyod\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/77/4e/5767edaccbfc227914ca774cb6ca9b628a08cbb59b9b4839296953a63d34/pyod-0.8.1.tar.gz (93kB)\n",
            "\u001b[K     |████████████████████████████████| 102kB 10.3MB/s \n",
            "\u001b[?25hCollecting catboost\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/96/6c/6608210b29649267de52001b09e369777ee2a5cfe1c71fa75eba82a4f2dc/catboost-0.24-cp36-none-manylinux1_x86_64.whl (65.9MB)\n",
            "\u001b[K     |████████████████████████████████| 65.9MB 52kB/s \n",
            "\u001b[?25hCollecting pandas-profiling>=2.8.0\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/b9/94/ef8ef4517540d13406fcc0b8adfd75336e014242c69bd4162ab46931f36a/pandas_profiling-2.8.0-py2.py3-none-any.whl (259kB)\n",
            "\u001b[K     |████████████████████████████████| 266kB 48.3MB/s \n",
            "\u001b[?25hCollecting kmodes>=0.10.1\n",
            "  Downloading https://files.pythonhosted.org/packages/b2/55/d8ec1ae1f7e1e202a8a4184c6852a3ee993b202b0459672c699d0ac18fc8/kmodes-0.10.2-py2.py3-none-any.whl\n",
            "Collecting datefinder>=0.7.0\n",
            "  Downloading https://files.pythonhosted.org/packages/0c/4f/29524c9ca35d2ba1a8a3c6c895b90fc92525cf0fe357f747133890953ebe/datefinder-0.7.1-py2.py3-none-any.whl\n",
            "Collecting DateTime>=4.3\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/73/22/a5297f3a1f92468cc737f8ce7ba6e5f245fcfafeae810ba37bd1039ea01c/DateTime-4.3-py2.py3-none-any.whl (60kB)\n",
            "\u001b[K     |████████████████████████████████| 61kB 8.0MB/s \n",
            "\u001b[?25hCollecting mlflow\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/00/2f/2529268d85af0a1521b0b7c137b63b731dff4784e1322fb3055403a959fb/mlflow-1.10.0-py3-none-any.whl (12.4MB)\n",
            "\u001b[K     |████████████████████████████████| 12.4MB 43.1MB/s \n",
            "\u001b[?25hRequirement already satisfied: imbalanced-learn in /usr/local/lib/python3.6/dist-packages (from pycaret==2.0) (0.4.3)\n",
            "Requirement already satisfied: pytz>=2017.2 in /usr/local/lib/python3.6/dist-packages (from pandas->pycaret==2.0) (2018.9)\n",
            "Requirement already satisfied: python-dateutil>=2.6.1 in /usr/local/lib/python3.6/dist-packages (from pandas->pycaret==2.0) (2.8.1)\n",
            "Requirement already satisfied: scipy>=1.0.1 in /usr/local/lib/python3.6/dist-packages (from seaborn->pycaret==2.0) (1.4.1)\n",
            "Requirement already satisfied: kiwisolver>=1.0.1 in /usr/local/lib/python3.6/dist-packages (from matplotlib->pycaret==2.0) (1.2.0)\n",
            "Requirement already satisfied: pyparsing!=2.0.4,!=2.1.2,!=2.1.6,>=2.0.1 in /usr/local/lib/python3.6/dist-packages (from matplotlib->pycaret==2.0) (2.4.7)\n",
            "Requirement already satisfied: cycler>=0.10 in /usr/local/lib/python3.6/dist-packages (from matplotlib->pycaret==2.0) (0.10.0)\n",
            "Requirement already satisfied: pickleshare in /usr/local/lib/python3.6/dist-packages (from IPython->pycaret==2.0) (0.7.5)\n",
            "Requirement already satisfied: decorator in /usr/local/lib/python3.6/dist-packages (from IPython->pycaret==2.0) (4.4.2)\n",
            "Requirement already satisfied: setuptools>=18.5 in /usr/local/lib/python3.6/dist-packages (from IPython->pycaret==2.0) (49.2.0)\n",
            "Requirement already satisfied: pygments in /usr/local/lib/python3.6/dist-packages (from IPython->pycaret==2.0) (2.1.3)\n",
            "Requirement already satisfied: traitlets>=4.2 in /usr/local/lib/python3.6/dist-packages (from IPython->pycaret==2.0) (4.3.3)\n",
            "Requirement already satisfied: pexpect; sys_platform != \"win32\" in /usr/local/lib/python3.6/dist-packages (from IPython->pycaret==2.0) (4.8.0)\n",
            "Requirement already satisfied: simplegeneric>0.8 in /usr/local/lib/python3.6/dist-packages (from IPython->pycaret==2.0) (0.8.1)\n",
            "Requirement already satisfied: prompt-toolkit<2.0.0,>=1.0.4 in /usr/local/lib/python3.6/dist-packages (from IPython->pycaret==2.0) (1.0.18)\n",
            "Collecting threadpoolctl>=2.0.0\n",
            "  Downloading https://files.pythonhosted.org/packages/f7/12/ec3f2e203afa394a149911729357aa48affc59c20e2c1c8297a60f33f133/threadpoolctl-2.1.0-py3-none-any.whl\n",
            "Requirement already satisfied: nbformat>=4.2.0 in /usr/local/lib/python3.6/dist-packages (from ipywidgets->pycaret==2.0) (5.0.7)\n",
            "Requirement already satisfied: ipykernel>=4.5.1 in /usr/local/lib/python3.6/dist-packages (from ipywidgets->pycaret==2.0) (4.10.1)\n",
            "Requirement already satisfied: widgetsnbextension~=3.5.0 in /usr/local/lib/python3.6/dist-packages (from ipywidgets->pycaret==2.0) (3.5.1)\n",
            "Requirement already satisfied: retrying>=1.3.3 in /usr/local/lib/python3.6/dist-packages (from plotly>=4.4.1->pycaret==2.0) (1.3.3)\n",
            "Requirement already satisfied: six in /usr/local/lib/python3.6/dist-packages (from plotly>=4.4.1->pycaret==2.0) (1.15.0)\n",
            "Requirement already satisfied: pillow in /usr/local/lib/python3.6/dist-packages (from wordcloud->pycaret==2.0) (7.0.0)\n",
            "Requirement already satisfied: colorlover>=0.2.1 in /usr/local/lib/python3.6/dist-packages (from cufflinks>=0.17.0->pycaret==2.0) (0.3.0)\n",
            "Requirement already satisfied: numba!=0.47,>=0.46 in /usr/local/lib/python3.6/dist-packages (from umap-learn->pycaret==2.0) (0.48.0)\n",
            "Requirement already satisfied: wheel>=0.23.0 in /usr/local/lib/python3.6/dist-packages (from pyLDAvis->pycaret==2.0) (0.34.2)\n",
            "Requirement already satisfied: jinja2>=2.7.2 in /usr/local/lib/python3.6/dist-packages (from pyLDAvis->pycaret==2.0) (2.11.2)\n",
            "Requirement already satisfied: numexpr in /usr/local/lib/python3.6/dist-packages (from pyLDAvis->pycaret==2.0) (2.7.1)\n",
            "Requirement already satisfied: pytest in /usr/local/lib/python3.6/dist-packages (from pyLDAvis->pycaret==2.0) (3.6.4)\n",
            "Requirement already satisfied: future in /usr/local/lib/python3.6/dist-packages (from pyLDAvis->pycaret==2.0) (0.16.0)\n",
            "Collecting funcy\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/ce/4b/6ffa76544e46614123de31574ad95758c421aae391a1764921b8a81e1eae/funcy-1.14.tar.gz (548kB)\n",
            "\u001b[K     |████████████████████████████████| 552kB 47.8MB/s \n",
            "\u001b[?25hRequirement already satisfied: smart-open>=1.2.1 in /usr/local/lib/python3.6/dist-packages (from gensim->pycaret==2.0) (2.1.0)\n",
            "Requirement already satisfied: srsly<1.1.0,>=1.0.2 in /usr/local/lib/python3.6/dist-packages (from spacy->pycaret==2.0) (1.0.2)\n",
            "Requirement already satisfied: murmurhash<1.1.0,>=0.28.0 in /usr/local/lib/python3.6/dist-packages (from spacy->pycaret==2.0) (1.0.2)\n",
            "Requirement already satisfied: requests<3.0.0,>=2.13.0 in /usr/local/lib/python3.6/dist-packages (from spacy->pycaret==2.0) (2.23.0)\n",
            "Requirement already satisfied: preshed<3.1.0,>=3.0.2 in /usr/local/lib/python3.6/dist-packages (from spacy->pycaret==2.0) (3.0.2)\n",
            "Requirement already satisfied: catalogue<1.1.0,>=0.0.7 in /usr/local/lib/python3.6/dist-packages (from spacy->pycaret==2.0) (1.0.0)\n",
            "Requirement already satisfied: wasabi<1.1.0,>=0.4.0 in /usr/local/lib/python3.6/dist-packages (from spacy->pycaret==2.0) (0.7.1)\n",
            "Requirement already satisfied: plac<1.2.0,>=0.9.6 in /usr/local/lib/python3.6/dist-packages (from spacy->pycaret==2.0) (1.1.3)\n",
            "Requirement already satisfied: blis<0.5.0,>=0.4.0 in /usr/local/lib/python3.6/dist-packages (from spacy->pycaret==2.0) (0.4.1)\n",
            "Requirement already satisfied: thinc==7.4.0 in /usr/local/lib/python3.6/dist-packages (from spacy->pycaret==2.0) (7.4.0)\n",
            "Requirement already satisfied: tqdm<5.0.0,>=4.38.0 in /usr/local/lib/python3.6/dist-packages (from spacy->pycaret==2.0) (4.41.1)\n",
            "Requirement already satisfied: cymem<2.1.0,>=2.0.2 in /usr/local/lib/python3.6/dist-packages (from spacy->pycaret==2.0) (2.0.3)\n",
            "Collecting combo\n",
            "  Downloading https://files.pythonhosted.org/packages/0a/2a/61b6ac584e75d8df16dc27962aa5fe99d76b09da5b6710e83d4862c84001/combo-0.1.1.tar.gz\n",
            "Collecting suod\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/a1/87/9170cabe1b5e10a7d095c0e28f2e30e7c1886a13f063de85d3cfacc06f4b/suod-0.0.4.tar.gz (2.1MB)\n",
            "\u001b[K     |████████████████████████████████| 2.1MB 34.2MB/s \n",
            "\u001b[?25hRequirement already satisfied: graphviz in /usr/local/lib/python3.6/dist-packages (from catboost->pycaret==2.0) (0.10.1)\n",
            "Collecting visions[type_image_path]==0.4.4\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/4a/03/5a45d542257830cf1d9da2cdc1c0bc6f55a9212937b70fdd6d7031b46d6c/visions-0.4.4-py3-none-any.whl (59kB)\n",
            "\u001b[K     |████████████████████████████████| 61kB 6.7MB/s \n",
            "\u001b[?25hRequirement already satisfied: missingno>=0.4.2 in /usr/local/lib/python3.6/dist-packages (from pandas-profiling>=2.8.0->pycaret==2.0) (0.4.2)\n",
            "Requirement already satisfied: astropy>=4.0 in /usr/local/lib/python3.6/dist-packages (from pandas-profiling>=2.8.0->pycaret==2.0) (4.0.1.post1)\n",
            "Collecting tangled-up-in-unicode>=0.0.6\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/4a/e2/e588ab9298d4989ce7fdb2b97d18aac878d99dbdc379a4476a09d9271b68/tangled_up_in_unicode-0.0.6-py3-none-any.whl (3.1MB)\n",
            "\u001b[K     |████████████████████████████████| 3.1MB 26.2MB/s \n",
            "\u001b[?25hCollecting confuse>=1.0.0\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/b5/6d/bedc0d1068bd244cee05843313cbec6cebb9f01f925538269bababc6d887/confuse-1.3.0-py2.py3-none-any.whl (64kB)\n",
            "\u001b[K     |████████████████████████████████| 71kB 8.3MB/s \n",
            "\u001b[?25hCollecting htmlmin>=0.1.12\n",
            "  Downloading https://files.pythonhosted.org/packages/b3/e7/fcd59e12169de19f0131ff2812077f964c6b960e7c09804d30a7bf2ab461/htmlmin-0.1.12.tar.gz\n",
            "Collecting phik>=0.9.10\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/01/5a/7ef1c04ce62cd72f900c06298dc2385840550d5c653a0dbc19109a5477e6/phik-0.10.0-py3-none-any.whl (599kB)\n",
            "\u001b[K     |████████████████████████████████| 604kB 41.9MB/s \n",
            "\u001b[?25hRequirement already satisfied: regex>=2017.02.08 in /usr/local/lib/python3.6/dist-packages (from datefinder>=0.7.0->pycaret==2.0) (2019.12.20)\n",
            "Collecting zope.interface\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/57/33/565274c28a11af60b7cfc0519d46bde4125fcd7d32ebc0a81b480d0e8da6/zope.interface-5.1.0-cp36-cp36m-manylinux2010_x86_64.whl (234kB)\n",
            "\u001b[K     |████████████████████████████████| 235kB 47.6MB/s \n",
            "\u001b[?25hCollecting sqlalchemy<=1.3.13\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/af/47/35edeb0f86c0b44934c05d961c893e223ef27e79e1f53b5e6f14820ff553/SQLAlchemy-1.3.13.tar.gz (6.0MB)\n",
            "\u001b[K     |████████████████████████████████| 6.0MB 42.7MB/s \n",
            "\u001b[?25hRequirement already satisfied: Flask in /usr/local/lib/python3.6/dist-packages (from mlflow->pycaret==2.0) (1.1.2)\n",
            "Requirement already satisfied: entrypoints in /usr/local/lib/python3.6/dist-packages (from mlflow->pycaret==2.0) (0.3)\n",
            "Collecting alembic\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/60/1e/cabc75a189de0fbb2841d0975243e59bde8b7822bacbb95008ac6fe9ad47/alembic-1.4.2.tar.gz (1.1MB)\n",
            "\u001b[K     |████████████████████████████████| 1.1MB 41.2MB/s \n",
            "\u001b[?25h  Installing build dependencies ... \u001b[?25l\u001b[?25hdone\n",
            "  Getting requirements to build wheel ... \u001b[?25l\u001b[?25hdone\n",
            "    Preparing wheel metadata ... \u001b[?25l\u001b[?25hdone\n",
            "Requirement already satisfied: protobuf>=3.6.0 in /usr/local/lib/python3.6/dist-packages (from mlflow->pycaret==2.0) (3.12.4)\n",
            "Collecting gunicorn; platform_system != \"Windows\"\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/69/ca/926f7cd3a2014b16870086b2d0fdc84a9e49473c68a8dff8b57f7c156f43/gunicorn-20.0.4-py2.py3-none-any.whl (77kB)\n",
            "\u001b[K     |████████████████████████████████| 81kB 9.1MB/s \n",
            "\u001b[?25hCollecting gitpython>=2.1.0\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/f9/1e/a45320cab182bf1c8656107b3d4c042e659742822fc6bff150d769a984dd/GitPython-3.1.7-py3-none-any.whl (158kB)\n",
            "\u001b[K     |████████████████████████████████| 163kB 44.0MB/s \n",
            "\u001b[?25hCollecting docker>=4.0.0\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/65/10/d18c41f2bd846c89c9030424a58be3d9752fac27780f8608284fa893feb4/docker-4.3.0-py2.py3-none-any.whl (145kB)\n",
            "\u001b[K     |████████████████████████████████| 153kB 48.0MB/s \n",
            "\u001b[?25hRequirement already satisfied: pyyaml in /usr/local/lib/python3.6/dist-packages (from mlflow->pycaret==2.0) (3.13)\n",
            "Collecting prometheus-flask-exporter\n",
            "  Downloading https://files.pythonhosted.org/packages/84/b0/7549899a75e7ef0be5f8969094d0709e5dcc51dc21d58cc86b8d69441dce/prometheus_flask_exporter-0.15.4.tar.gz\n",
            "Requirement already satisfied: click>=7.0 in /usr/local/lib/python3.6/dist-packages (from mlflow->pycaret==2.0) (7.1.2)\n",
            "Requirement already satisfied: sqlparse in /usr/local/lib/python3.6/dist-packages (from mlflow->pycaret==2.0) (0.3.1)\n",
            "Collecting databricks-cli>=0.8.7\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/1e/57/5c2d6b83cb8753d12f548e89f91037632baa8289677c1b2ab2adf14bf6b2/databricks-cli-0.11.0.tar.gz (49kB)\n",
            "\u001b[K     |████████████████████████████████| 51kB 6.7MB/s \n",
            "\u001b[?25hCollecting azure-storage-blob>=12.0\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/6d/3d/31614573e8a197db12d8ab47a7fd813f15bd4a4b5c64e85d23b865de5b9b/azure_storage_blob-12.3.2-py2.py3-none-any.whl (280kB)\n",
            "\u001b[K     |████████████████████████████████| 286kB 47.8MB/s \n",
            "\u001b[?25hCollecting querystring-parser\n",
            "  Downloading https://files.pythonhosted.org/packages/4a/fa/f54f5662e0eababf0c49e92fd94bf178888562c0e7b677c8941bbbcd1bd6/querystring_parser-1.2.4.tar.gz\n",
            "Collecting gorilla\n",
            "  Downloading https://files.pythonhosted.org/packages/e3/56/5a683944cbfc77e429c6f03c636ca50504a785f60ffae91ddd7f5f7bb520/gorilla-0.3.0-py2.py3-none-any.whl\n",
            "Requirement already satisfied: cloudpickle in /usr/local/lib/python3.6/dist-packages (from mlflow->pycaret==2.0) (1.3.0)\n",
            "Requirement already satisfied: ipython-genutils in /usr/local/lib/python3.6/dist-packages (from traitlets>=4.2->IPython->pycaret==2.0) (0.2.0)\n",
            "Requirement already satisfied: ptyprocess>=0.5 in /usr/local/lib/python3.6/dist-packages (from pexpect; sys_platform != \"win32\"->IPython->pycaret==2.0) (0.6.0)\n",
            "Requirement already satisfied: wcwidth in /usr/local/lib/python3.6/dist-packages (from prompt-toolkit<2.0.0,>=1.0.4->IPython->pycaret==2.0) (0.2.5)\n",
            "Requirement already satisfied: jupyter-core in /usr/local/lib/python3.6/dist-packages (from nbformat>=4.2.0->ipywidgets->pycaret==2.0) (4.6.3)\n",
            "Requirement already satisfied: jsonschema!=2.5.0,>=2.4 in /usr/local/lib/python3.6/dist-packages (from nbformat>=4.2.0->ipywidgets->pycaret==2.0) (2.6.0)\n",
            "Requirement already satisfied: jupyter-client in /usr/local/lib/python3.6/dist-packages (from ipykernel>=4.5.1->ipywidgets->pycaret==2.0) (5.3.5)\n",
            "Requirement already satisfied: tornado>=4.0 in /usr/local/lib/python3.6/dist-packages (from ipykernel>=4.5.1->ipywidgets->pycaret==2.0) (5.1.1)\n",
            "Requirement already satisfied: notebook>=4.4.1 in /usr/local/lib/python3.6/dist-packages (from widgetsnbextension~=3.5.0->ipywidgets->pycaret==2.0) (5.3.1)\n",
            "Requirement already satisfied: llvmlite<0.32.0,>=0.31.0dev0 in /usr/local/lib/python3.6/dist-packages (from numba!=0.47,>=0.46->umap-learn->pycaret==2.0) (0.31.0)\n",
            "Requirement already satisfied: MarkupSafe>=0.23 in /usr/local/lib/python3.6/dist-packages (from jinja2>=2.7.2->pyLDAvis->pycaret==2.0) (1.1.1)\n",
            "Requirement already satisfied: pluggy<0.8,>=0.5 in /usr/local/lib/python3.6/dist-packages (from pytest->pyLDAvis->pycaret==2.0) (0.7.1)\n",
            "Requirement already satisfied: py>=1.5.0 in /usr/local/lib/python3.6/dist-packages (from pytest->pyLDAvis->pycaret==2.0) (1.9.0)\n",
            "Requirement already satisfied: more-itertools>=4.0.0 in /usr/local/lib/python3.6/dist-packages (from pytest->pyLDAvis->pycaret==2.0) (8.4.0)\n",
            "Requirement already satisfied: attrs>=17.4.0 in /usr/local/lib/python3.6/dist-packages (from pytest->pyLDAvis->pycaret==2.0) (19.3.0)\n",
            "Requirement already satisfied: atomicwrites>=1.0 in /usr/local/lib/python3.6/dist-packages (from pytest->pyLDAvis->pycaret==2.0) (1.4.0)\n",
            "Requirement already satisfied: boto3 in /usr/local/lib/python3.6/dist-packages (from smart-open>=1.2.1->gensim->pycaret==2.0) (1.14.37)\n",
            "Requirement already satisfied: boto in /usr/local/lib/python3.6/dist-packages (from smart-open>=1.2.1->gensim->pycaret==2.0) (2.49.0)\n",
            "Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.6/dist-packages (from requests<3.0.0,>=2.13.0->spacy->pycaret==2.0) (2020.6.20)\n",
            "Requirement already satisfied: chardet<4,>=3.0.2 in /usr/local/lib/python3.6/dist-packages (from requests<3.0.0,>=2.13.0->spacy->pycaret==2.0) (3.0.4)\n",
            "Requirement already satisfied: idna<3,>=2.5 in /usr/local/lib/python3.6/dist-packages (from requests<3.0.0,>=2.13.0->spacy->pycaret==2.0) (2.10)\n",
            "Requirement already satisfied: urllib3!=1.25.0,!=1.25.1,<1.26,>=1.21.1 in /usr/local/lib/python3.6/dist-packages (from requests<3.0.0,>=2.13.0->spacy->pycaret==2.0) (1.24.3)\n",
            "Requirement already satisfied: importlib-metadata>=0.20; python_version < \"3.8\" in /usr/local/lib/python3.6/dist-packages (from catalogue<1.1.0,>=0.0.7->spacy->pycaret==2.0) (1.7.0)\n",
            "Requirement already satisfied: networkx>=2.4 in /usr/local/lib/python3.6/dist-packages (from visions[type_image_path]==0.4.4->pandas-profiling>=2.8.0->pycaret==2.0) (2.4)\n",
            "Collecting imagehash; extra == \"type_image_path\"\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/1a/5d/cc81830be3c4705a46cdbca74439b67f1017881383ba0127c41c4cecb7b3/ImageHash-4.1.0.tar.gz (291kB)\n",
            "\u001b[K     |████████████████████████████████| 296kB 46.9MB/s \n",
            "\u001b[?25hRequirement already satisfied: Werkzeug>=0.15 in /usr/local/lib/python3.6/dist-packages (from Flask->mlflow->pycaret==2.0) (1.0.1)\n",
            "Requirement already satisfied: itsdangerous>=0.24 in /usr/local/lib/python3.6/dist-packages (from Flask->mlflow->pycaret==2.0) (1.1.0)\n",
            "Collecting Mako\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/a6/37/0e706200d22172eb8fa17d68a7ae22dec7631a0a92266634fb518a88a5b2/Mako-1.1.3-py2.py3-none-any.whl (75kB)\n",
            "\u001b[K     |████████████████████████████████| 81kB 10.0MB/s \n",
            "\u001b[?25hCollecting python-editor>=0.3\n",
            "  Downloading https://files.pythonhosted.org/packages/c6/d3/201fc3abe391bbae6606e6f1d598c15d367033332bd54352b12f35513717/python_editor-1.0.4-py3-none-any.whl\n",
            "Collecting gitdb<5,>=4.0.1\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/48/11/d1800bca0a3bae820b84b7d813ad1eff15a48a64caea9c823fc8c1b119e8/gitdb-4.0.5-py3-none-any.whl (63kB)\n",
            "\u001b[K     |████████████████████████████████| 71kB 9.6MB/s \n",
            "\u001b[?25hCollecting websocket-client>=0.32.0\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/4c/5f/f61b420143ed1c8dc69f9eaec5ff1ac36109d52c80de49d66e0c36c3dfdf/websocket_client-0.57.0-py2.py3-none-any.whl (200kB)\n",
            "\u001b[K     |████████████████████████████████| 204kB 49.0MB/s \n",
            "\u001b[?25hRequirement already satisfied: prometheus_client in /usr/local/lib/python3.6/dist-packages (from prometheus-flask-exporter->mlflow->pycaret==2.0) (0.8.0)\n",
            "Requirement already satisfied: tabulate>=0.7.7 in /usr/local/lib/python3.6/dist-packages (from databricks-cli>=0.8.7->mlflow->pycaret==2.0) (0.8.7)\n",
            "Collecting azure-core<2.0.0,>=1.6.0\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/5b/e3/acb0c45c0b7afa33eca9fadb47f32cbfb95161e3719fcbe953d689b881bc/azure_core-1.8.0-py2.py3-none-any.whl (121kB)\n",
            "\u001b[K     |████████████████████████████████| 122kB 47.6MB/s \n",
            "\u001b[?25hCollecting msrest>=0.6.10\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/d9/ed/8e1b75721ad983c1672cd968ad3ae374d2e94767edff6f0b72a15dfde933/msrest-0.6.18-py2.py3-none-any.whl (84kB)\n",
            "\u001b[K     |████████████████████████████████| 92kB 10.8MB/s \n",
            "\u001b[?25hCollecting cryptography>=2.1.4\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/ba/91/84a29d6a27fd6dfc21f475704c4d2053d58ed7a4033c2b0ce1b4ca4d03d9/cryptography-3.0-cp35-abi3-manylinux2010_x86_64.whl (2.7MB)\n",
            "\u001b[K     |████████████████████████████████| 2.7MB 40.5MB/s \n",
            "\u001b[?25hRequirement already satisfied: pyzmq>=13 in /usr/local/lib/python3.6/dist-packages (from jupyter-client->ipykernel>=4.5.1->ipywidgets->pycaret==2.0) (19.0.2)\n",
            "Requirement already satisfied: Send2Trash in /usr/local/lib/python3.6/dist-packages (from notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets->pycaret==2.0) (1.5.0)\n",
            "Requirement already satisfied: terminado>=0.8.1 in /usr/local/lib/python3.6/dist-packages (from notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets->pycaret==2.0) (0.8.3)\n",
            "Requirement already satisfied: nbconvert in /usr/local/lib/python3.6/dist-packages (from notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets->pycaret==2.0) (5.6.1)\n",
            "Requirement already satisfied: s3transfer<0.4.0,>=0.3.0 in /usr/local/lib/python3.6/dist-packages (from boto3->smart-open>=1.2.1->gensim->pycaret==2.0) (0.3.3)\n",
            "Requirement already satisfied: jmespath<1.0.0,>=0.7.1 in /usr/local/lib/python3.6/dist-packages (from boto3->smart-open>=1.2.1->gensim->pycaret==2.0) (0.10.0)\n",
            "Requirement already satisfied: botocore<1.18.0,>=1.17.37 in /usr/local/lib/python3.6/dist-packages (from boto3->smart-open>=1.2.1->gensim->pycaret==2.0) (1.17.37)\n",
            "Requirement already satisfied: zipp>=0.5 in /usr/local/lib/python3.6/dist-packages (from importlib-metadata>=0.20; python_version < \"3.8\"->catalogue<1.1.0,>=0.0.7->spacy->pycaret==2.0) (3.1.0)\n",
            "Requirement already satisfied: PyWavelets in /usr/local/lib/python3.6/dist-packages (from imagehash; extra == \"type_image_path\"->visions[type_image_path]==0.4.4->pandas-profiling>=2.8.0->pycaret==2.0) (1.1.1)\n",
            "Collecting smmap<4,>=3.0.1\n",
            "  Downloading https://files.pythonhosted.org/packages/b0/9a/4d409a6234eb940e6a78dfdfc66156e7522262f5f2fecca07dc55915952d/smmap-3.0.4-py2.py3-none-any.whl\n",
            "Collecting isodate>=0.6.0\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/9b/9f/b36f7774ff5ea8e428fdcfc4bb332c39ee5b9362ddd3d40d9516a55221b2/isodate-0.6.0-py2.py3-none-any.whl (45kB)\n",
            "\u001b[K     |████████████████████████████████| 51kB 7.3MB/s \n",
            "\u001b[?25hRequirement already satisfied: requests-oauthlib>=0.5.0 in /usr/local/lib/python3.6/dist-packages (from msrest>=0.6.10->azure-storage-blob>=12.0->mlflow->pycaret==2.0) (1.3.0)\n",
            "Requirement already satisfied: cffi!=1.11.3,>=1.8 in /usr/local/lib/python3.6/dist-packages (from cryptography>=2.1.4->azure-storage-blob>=12.0->mlflow->pycaret==2.0) (1.14.1)\n",
            "Requirement already satisfied: testpath in /usr/local/lib/python3.6/dist-packages (from nbconvert->notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets->pycaret==2.0) (0.4.4)\n",
            "Requirement already satisfied: mistune<2,>=0.8.1 in /usr/local/lib/python3.6/dist-packages (from nbconvert->notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets->pycaret==2.0) (0.8.4)\n",
            "Requirement already satisfied: pandocfilters>=1.4.1 in /usr/local/lib/python3.6/dist-packages (from nbconvert->notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets->pycaret==2.0) (1.4.2)\n",
            "Requirement already satisfied: bleach in /usr/local/lib/python3.6/dist-packages (from nbconvert->notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets->pycaret==2.0) (3.1.5)\n",
            "Requirement already satisfied: defusedxml in /usr/local/lib/python3.6/dist-packages (from nbconvert->notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets->pycaret==2.0) (0.6.0)\n",
            "Requirement already satisfied: docutils<0.16,>=0.10 in /usr/local/lib/python3.6/dist-packages (from botocore<1.18.0,>=1.17.37->boto3->smart-open>=1.2.1->gensim->pycaret==2.0) (0.15.2)\n",
            "Requirement already satisfied: oauthlib>=3.0.0 in /usr/local/lib/python3.6/dist-packages (from requests-oauthlib>=0.5.0->msrest>=0.6.10->azure-storage-blob>=12.0->mlflow->pycaret==2.0) (3.1.0)\n",
            "Requirement already satisfied: pycparser in /usr/local/lib/python3.6/dist-packages (from cffi!=1.11.3,>=1.8->cryptography>=2.1.4->azure-storage-blob>=12.0->mlflow->pycaret==2.0) (2.20)\n",
            "Requirement already satisfied: packaging in /usr/local/lib/python3.6/dist-packages (from bleach->nbconvert->notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets->pycaret==2.0) (20.4)\n",
            "Requirement already satisfied: webencodings in /usr/local/lib/python3.6/dist-packages (from bleach->nbconvert->notebook>=4.4.1->widgetsnbextension~=3.5.0->ipywidgets->pycaret==2.0) (0.5.1)\n",
            "Building wheels for collected packages: alembic\n",
            "  Building wheel for alembic (PEP 517) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for alembic: filename=alembic-1.4.2-cp36-none-any.whl size=159543 sha256=2d7615fcc6e320dd8c83d6a7543f91cb675a7315b5edfb9a848f9a078053fb85\n",
            "  Stored in directory: /root/.cache/pip/wheels/1f/04/83/76023f7a4c14688c0b5c2682a96392cfdd3ee4449eaaa287ef\n",
            "Successfully built alembic\n",
            "Building wheels for collected packages: pycaret, pyLDAvis, pyod, funcy, combo, suod, htmlmin, sqlalchemy, prometheus-flask-exporter, databricks-cli, querystring-parser, imagehash\n",
            "  Building wheel for pycaret (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for pycaret: filename=pycaret-2.0-cp36-none-any.whl size=247238 sha256=9451dfaffe82ca0e4e12997dd5a020c28e3ea15a753837455825cc62f690c8a7\n",
            "  Stored in directory: /tmp/pip-ephem-wheel-cache-hnezc9m1/wheels/56/ce/94/89663fa75fe49093e56d12596743a8ccebef655009d58ff0c0\n",
            "  Building wheel for pyLDAvis (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for pyLDAvis: filename=pyLDAvis-2.1.2-py2.py3-none-any.whl size=97711 sha256=cc9099e54d77b3ec2dbfe446af3ec31b662866d22bc3a6c56aebfedf31e162e8\n",
            "  Stored in directory: /root/.cache/pip/wheels/98/71/24/513a99e58bb6b8465bae4d2d5e9dba8f0bef8179e3051ac414\n",
            "  Building wheel for pyod (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for pyod: filename=pyod-0.8.1-cp36-none-any.whl size=105653 sha256=731f1f2022d271cad83b95d3aea71abf5caafccab75b6086447d4c32eb5dd998\n",
            "  Stored in directory: /root/.cache/pip/wheels/2e/ca/18/727e9d98a41f5f4385a97d5b429f3a9c8fbee13f9780c18642\n",
            "  Building wheel for funcy (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for funcy: filename=funcy-1.14-py2.py3-none-any.whl size=32042 sha256=045138224704e55a67deccd7e29a326246cef78b2b6a764d1bdcb2de5f75ff34\n",
            "  Stored in directory: /root/.cache/pip/wheels/20/5a/d8/1d875df03deae6f178dfdf70238cca33f948ef8a6f5209f2eb\n",
            "  Building wheel for combo (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for combo: filename=combo-0.1.1-cp36-none-any.whl size=42111 sha256=f5de7bc8e7b5db30e82364fdaca399593376de03b8c570c96d1e3ad584bd85c1\n",
            "  Stored in directory: /root/.cache/pip/wheels/55/ec/e5/a2331372c676c467e70c6646e646edf6997d5c4905b8c0f5e6\n",
            "  Building wheel for suod (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for suod: filename=suod-0.0.4-cp36-none-any.whl size=2167157 sha256=09cd1a717457ca1e1f769683f69827fa544be7d7432147d754e1ff918c373ec6\n",
            "  Stored in directory: /root/.cache/pip/wheels/57/55/e5/a4fca65bba231f6d0115059b589148774b41faea25b3f2aa27\n",
            "  Building wheel for htmlmin (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for htmlmin: filename=htmlmin-0.1.12-cp36-none-any.whl size=27084 sha256=85e30804a101ef43cafbe68c14df59c846cc33825b59afc46b09dd67a49b7da0\n",
            "  Stored in directory: /root/.cache/pip/wheels/43/07/ac/7c5a9d708d65247ac1f94066cf1db075540b85716c30255459\n",
            "  Building wheel for sqlalchemy (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for sqlalchemy: filename=SQLAlchemy-1.3.13-cp36-cp36m-linux_x86_64.whl size=1217151 sha256=6fc559bf3218fbc8927531a1ae95585f7cd1c41e9b1b3dba9f99dbf265301dc4\n",
            "  Stored in directory: /root/.cache/pip/wheels/b3/35/98/4c9cb3fd63d21d5606b972dd70643769745adf60e622467b71\n",
            "  Building wheel for prometheus-flask-exporter (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for prometheus-flask-exporter: filename=prometheus_flask_exporter-0.15.4-cp36-none-any.whl size=16454 sha256=a086e3f5ddf6a32201b6e381a531111210a98a5964231735bcabbb2d2afd9004\n",
            "  Stored in directory: /root/.cache/pip/wheels/4f/b4/70/b18fa12c1c0a30fd542767dbbcdac225c6aae012fa1b3124e4\n",
            "  Building wheel for databricks-cli (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for databricks-cli: filename=databricks_cli-0.11.0-cp36-none-any.whl size=90300 sha256=42283c6579cf379e10ab24a2beda67f6af98f9537c1d750a1ced302227769c8d\n",
            "  Stored in directory: /root/.cache/pip/wheels/63/d0/4f/3deeca1f4c47a6aca7c2c6a6e2bf272391565dc86a7718a59b\n",
            "  Building wheel for querystring-parser (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for querystring-parser: filename=querystring_parser-1.2.4-cp36-none-any.whl size=7079 sha256=4362b33092620c2d85d89b741bc01e3f9993e2571d1caa57ca41d5da53210357\n",
            "  Stored in directory: /root/.cache/pip/wheels/1e/41/34/23ebf5d1089a9aed847951e0ee375426eb4ad0a7079d88d41e\n",
            "  Building wheel for imagehash (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for imagehash: filename=ImageHash-4.1.0-py2.py3-none-any.whl size=291990 sha256=35274b1a839753923467aba0a29ce8cc7eeb5422791c9a612591c17c2eceb19d\n",
            "  Stored in directory: /root/.cache/pip/wheels/07/1c/dc/6831446f09feb8cc199ec73a0f2f0703253f6ae013a22f4be9\n",
            "Successfully built pycaret pyLDAvis pyod funcy combo suod htmlmin sqlalchemy prometheus-flask-exporter databricks-cli querystring-parser imagehash\n",
            "\u001b[31mERROR: pandas-profiling 2.8.0 has requirement tqdm>=4.43.0, but you'll have tqdm 4.41.1 which is incompatible.\u001b[0m\n",
            "Installing collected packages: threadpoolctl, scikit-learn, yellowbrick, lightgbm, funcy, pyLDAvis, combo, suod, pyod, catboost, tangled-up-in-unicode, imagehash, visions, confuse, htmlmin, phik, pandas-profiling, kmodes, datefinder, zope.interface, DateTime, sqlalchemy, Mako, python-editor, alembic, gunicorn, smmap, gitdb, gitpython, websocket-client, docker, prometheus-flask-exporter, databricks-cli, azure-core, isodate, msrest, cryptography, azure-storage-blob, querystring-parser, gorilla, mlflow, pycaret\n",
            "  Found existing installation: scikit-learn 0.22.2.post1\n",
            "    Uninstalling scikit-learn-0.22.2.post1:\n",
            "      Successfully uninstalled scikit-learn-0.22.2.post1\n",
            "  Found existing installation: yellowbrick 0.9.1\n",
            "    Uninstalling yellowbrick-0.9.1:\n",
            "      Successfully uninstalled yellowbrick-0.9.1\n",
            "  Found existing installation: lightgbm 2.2.3\n",
            "    Uninstalling lightgbm-2.2.3:\n",
            "      Successfully uninstalled lightgbm-2.2.3\n",
            "  Found existing installation: pandas-profiling 1.4.1\n",
            "    Uninstalling pandas-profiling-1.4.1:\n",
            "      Successfully uninstalled pandas-profiling-1.4.1\n",
            "  Found existing installation: SQLAlchemy 1.3.18\n",
            "    Uninstalling SQLAlchemy-1.3.18:\n",
            "      Successfully uninstalled SQLAlchemy-1.3.18\n",
            "Successfully installed DateTime-4.3 Mako-1.1.3 alembic-1.4.2 azure-core-1.8.0 azure-storage-blob-12.3.2 catboost-0.24 combo-0.1.1 confuse-1.3.0 cryptography-3.0 databricks-cli-0.11.0 datefinder-0.7.1 docker-4.3.0 funcy-1.14 gitdb-4.0.5 gitpython-3.1.7 gorilla-0.3.0 gunicorn-20.0.4 htmlmin-0.1.12 imagehash-4.1.0 isodate-0.6.0 kmodes-0.10.2 lightgbm-2.3.1 mlflow-1.10.0 msrest-0.6.18 pandas-profiling-2.8.0 phik-0.10.0 prometheus-flask-exporter-0.15.4 pyLDAvis-2.1.2 pycaret-2.0 pyod-0.8.1 python-editor-1.0.4 querystring-parser-1.2.4 scikit-learn-0.23.2 smmap-3.0.4 sqlalchemy-1.3.13 suod-0.0.4 tangled-up-in-unicode-0.0.6 threadpoolctl-2.1.0 visions-0.4.4 websocket-client-0.57.0 yellowbrick-1.1 zope.interface-5.1.0\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab_type": "code",
        "id": "lUvE187JEQm3",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 204
        },
        "outputId": "e6083dca-71b1-40b6-fc25-3256960e4dfb"
      },
      "source": [
        "from pycaret.datasets import get_data\n",
        "dataset = get_data('diamond')"
      ],
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Carat Weight</th>\n",
              "      <th>Cut</th>\n",
              "      <th>Color</th>\n",
              "      <th>Clarity</th>\n",
              "      <th>Polish</th>\n",
              "      <th>Symmetry</th>\n",
              "      <th>Report</th>\n",
              "      <th>Price</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1.10</td>\n",
              "      <td>Ideal</td>\n",
              "      <td>H</td>\n",
              "      <td>SI1</td>\n",
              "      <td>VG</td>\n",
              "      <td>EX</td>\n",
              "      <td>GIA</td>\n",
              "      <td>5169</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>0.83</td>\n",
              "      <td>Ideal</td>\n",
              "      <td>H</td>\n",
              "      <td>VS1</td>\n",
              "      <td>ID</td>\n",
              "      <td>ID</td>\n",
              "      <td>AGSL</td>\n",
              "      <td>3470</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>0.85</td>\n",
              "      <td>Ideal</td>\n",
              "      <td>H</td>\n",
              "      <td>SI1</td>\n",
              "      <td>EX</td>\n",
              "      <td>EX</td>\n",
              "      <td>GIA</td>\n",
              "      <td>3183</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>0.91</td>\n",
              "      <td>Ideal</td>\n",
              "      <td>E</td>\n",
              "      <td>SI1</td>\n",
              "      <td>VG</td>\n",
              "      <td>VG</td>\n",
              "      <td>GIA</td>\n",
              "      <td>4370</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>0.83</td>\n",
              "      <td>Ideal</td>\n",
              "      <td>G</td>\n",
              "      <td>SI1</td>\n",
              "      <td>EX</td>\n",
              "      <td>EX</td>\n",
              "      <td>GIA</td>\n",
              "      <td>3171</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   Carat Weight    Cut Color Clarity Polish Symmetry Report  Price\n",
              "0          1.10  Ideal     H     SI1     VG       EX    GIA   5169\n",
              "1          0.83  Ideal     H     VS1     ID       ID   AGSL   3470\n",
              "2          0.85  Ideal     H     SI1     EX       EX    GIA   3183\n",
              "3          0.91  Ideal     E     SI1     VG       VG    GIA   4370\n",
              "4          0.83  Ideal     G     SI1     EX       EX    GIA   3171"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab_type": "code",
        "id": "hXmaL1xFEQnj",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 53
        },
        "outputId": "da4af24e-212b-4c5f-a4ba-42dbbd7a2953"
      },
      "source": [
        "data = dataset.sample(frac=0.95, random_state=786).reset_index(drop=True)\n",
        "data_unseen = dataset.drop(data.index).reset_index(drop=True)\n",
        "\n",
        "print('Data for Modeling: ' + str(data.shape))\n",
        "print('Unseen Data For Predictions: ' + str(data_unseen.shape))"
      ],
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Data for Modeling: (5700, 8)\n",
            "Unseen Data For Predictions: (300, 8)\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "3sXuMNuqG6PG",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 958,
          "referenced_widgets": [
            "efaff962f0a94c8d8f5d06311e023506",
            "c2e2060613d444078b48b60e30a112e7",
            "09690916f8634c01b8b289d83119e178",
            "dbb0c8ed8d2f4b37a492d777d1cfcd48",
            "5db0cd1626b044b6ada0e461e2d7c94b",
            "8a5e8367e06b49dcbe1550b7ce9a8380"
          ]
        },
        "outputId": "0bd58ff5-896d-4656-96c4-535089378636"
      },
      "source": [
        "from pycaret.regression import *\n",
        "exp_reg101 = setup(data = data, target = 'Price', session_id=123)"
      ],
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            " \n",
            "Setup Succesfully Completed.\n"
          ],
          "name": "stdout"
        },
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "<style  type=\"text/css\" >\n",
              "</style><table id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >Description</th>        <th class=\"col_heading level0 col1\" >Value</th>    </tr></thead><tbody>\n",
              "                <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row0_col0\" class=\"data row0 col0\" >session_id</td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row0_col1\" class=\"data row0 col1\" >123</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row1_col0\" class=\"data row1 col0\" >Transform Target </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row1_col1\" class=\"data row1 col1\" >False</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row2_col0\" class=\"data row2 col0\" >Transform Target Method</td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row2_col1\" class=\"data row2 col1\" >None</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row3_col0\" class=\"data row3 col0\" >Original Data</td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row3_col1\" class=\"data row3 col1\" >(5700, 8)</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row4_col0\" class=\"data row4 col0\" >Missing Values </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row4_col1\" class=\"data row4 col1\" >False</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row5_col0\" class=\"data row5 col0\" >Numeric Features </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row5_col1\" class=\"data row5 col1\" >1</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row6_col0\" class=\"data row6 col0\" >Categorical Features </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row6_col1\" class=\"data row6 col1\" >6</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row7_col0\" class=\"data row7 col0\" >Ordinal Features </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row7_col1\" class=\"data row7 col1\" >False</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row8_col0\" class=\"data row8 col0\" >High Cardinality Features </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row8_col1\" class=\"data row8 col1\" >False</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row9_col0\" class=\"data row9 col0\" >High Cardinality Method </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row9_col1\" class=\"data row9 col1\" >None</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row10\" class=\"row_heading level0 row10\" >10</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row10_col0\" class=\"data row10 col0\" >Sampled Data</td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row10_col1\" class=\"data row10 col1\" >(5700, 8)</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row11\" class=\"row_heading level0 row11\" >11</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row11_col0\" class=\"data row11 col0\" >Transformed Train Set</td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row11_col1\" class=\"data row11 col1\" >(3989, 29)</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row12\" class=\"row_heading level0 row12\" >12</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row12_col0\" class=\"data row12 col0\" >Transformed Test Set</td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row12_col1\" class=\"data row12 col1\" >(1711, 29)</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row13\" class=\"row_heading level0 row13\" >13</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row13_col0\" class=\"data row13 col0\" >Numeric Imputer </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row13_col1\" class=\"data row13 col1\" >mean</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row14\" class=\"row_heading level0 row14\" >14</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row14_col0\" class=\"data row14 col0\" >Categorical Imputer </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row14_col1\" class=\"data row14 col1\" >constant</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row15\" class=\"row_heading level0 row15\" >15</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row15_col0\" class=\"data row15 col0\" >Normalize </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row15_col1\" class=\"data row15 col1\" >False</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row16\" class=\"row_heading level0 row16\" >16</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row16_col0\" class=\"data row16 col0\" >Normalize Method </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row16_col1\" class=\"data row16 col1\" >None</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row17\" class=\"row_heading level0 row17\" >17</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row17_col0\" class=\"data row17 col0\" >Transformation </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row17_col1\" class=\"data row17 col1\" >False</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row18\" class=\"row_heading level0 row18\" >18</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row18_col0\" class=\"data row18 col0\" >Transformation Method </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row18_col1\" class=\"data row18 col1\" >None</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row19\" class=\"row_heading level0 row19\" >19</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row19_col0\" class=\"data row19 col0\" >PCA </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row19_col1\" class=\"data row19 col1\" >False</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row20\" class=\"row_heading level0 row20\" >20</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row20_col0\" class=\"data row20 col0\" >PCA Method </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row20_col1\" class=\"data row20 col1\" >None</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row21\" class=\"row_heading level0 row21\" >21</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row21_col0\" class=\"data row21 col0\" >PCA Components </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row21_col1\" class=\"data row21 col1\" >None</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row22\" class=\"row_heading level0 row22\" >22</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row22_col0\" class=\"data row22 col0\" >Ignore Low Variance </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row22_col1\" class=\"data row22 col1\" >False</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row23\" class=\"row_heading level0 row23\" >23</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row23_col0\" class=\"data row23 col0\" >Combine Rare Levels </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row23_col1\" class=\"data row23 col1\" >False</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row24\" class=\"row_heading level0 row24\" >24</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row24_col0\" class=\"data row24 col0\" >Rare Level Threshold </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row24_col1\" class=\"data row24 col1\" >None</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row25\" class=\"row_heading level0 row25\" >25</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row25_col0\" class=\"data row25 col0\" >Numeric Binning </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row25_col1\" class=\"data row25 col1\" >False</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row26\" class=\"row_heading level0 row26\" >26</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row26_col0\" class=\"data row26 col0\" >Remove Outliers </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row26_col1\" class=\"data row26 col1\" >False</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row27\" class=\"row_heading level0 row27\" >27</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row27_col0\" class=\"data row27 col0\" >Outliers Threshold </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row27_col1\" class=\"data row27 col1\" >None</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row28\" class=\"row_heading level0 row28\" >28</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row28_col0\" class=\"data row28 col0\" >Remove Multicollinearity </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row28_col1\" class=\"data row28 col1\" >False</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row29\" class=\"row_heading level0 row29\" >29</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row29_col0\" class=\"data row29 col0\" >Multicollinearity Threshold </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row29_col1\" class=\"data row29 col1\" >None</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row30\" class=\"row_heading level0 row30\" >30</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row30_col0\" class=\"data row30 col0\" >Clustering </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row30_col1\" class=\"data row30 col1\" >False</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row31\" class=\"row_heading level0 row31\" >31</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row31_col0\" class=\"data row31 col0\" >Clustering Iteration </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row31_col1\" class=\"data row31 col1\" >None</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row32\" class=\"row_heading level0 row32\" >32</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row32_col0\" class=\"data row32 col0\" >Polynomial Features </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row32_col1\" class=\"data row32 col1\" >False</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row33\" class=\"row_heading level0 row33\" >33</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row33_col0\" class=\"data row33 col0\" >Polynomial Degree </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row33_col1\" class=\"data row33 col1\" >None</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row34\" class=\"row_heading level0 row34\" >34</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row34_col0\" class=\"data row34 col0\" >Trignometry Features </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row34_col1\" class=\"data row34 col1\" >False</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row35\" class=\"row_heading level0 row35\" >35</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row35_col0\" class=\"data row35 col0\" >Polynomial Threshold </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row35_col1\" class=\"data row35 col1\" >None</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row36\" class=\"row_heading level0 row36\" >36</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row36_col0\" class=\"data row36 col0\" >Group Features </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row36_col1\" class=\"data row36 col1\" >False</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row37\" class=\"row_heading level0 row37\" >37</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row37_col0\" class=\"data row37 col0\" >Feature Selection </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row37_col1\" class=\"data row37 col1\" >False</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row38\" class=\"row_heading level0 row38\" >38</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row38_col0\" class=\"data row38 col0\" >Features Selection Threshold </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row38_col1\" class=\"data row38 col1\" >None</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row39\" class=\"row_heading level0 row39\" >39</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row39_col0\" class=\"data row39 col0\" >Feature Interaction </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row39_col1\" class=\"data row39 col1\" >False</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row40\" class=\"row_heading level0 row40\" >40</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row40_col0\" class=\"data row40 col0\" >Feature Ratio </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row40_col1\" class=\"data row40 col1\" >False</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002level0_row41\" class=\"row_heading level0 row41\" >41</th>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row41_col0\" class=\"data row41 col0\" >Interaction Threshold </td>\n",
              "                        <td id=\"T_a67c65a8_dc2e_11ea_945e_0242ac1c0002row41_col1\" class=\"data row41 col1\" >None</td>\n",
              "            </tr>\n",
              "    </tbody></table>"
            ],
            "text/plain": [
              "<pandas.io.formats.style.Styler at 0x7fb25caa2390>"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab_type": "code",
        "id": "FGCoUiQpEQpz",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 292,
          "referenced_widgets": [
            "f82b0cd6d54b427ea21cf2a5b2958c21",
            "0f57ccbc1ce543ad9b7d837c7fe03595",
            "2dae5a1a055343ea88a268f14cc53a49"
          ]
        },
        "outputId": "79640529-8cdd-4875-b6c7-ce0544252663"
      },
      "source": [
        "lightgbm = create_model('lightgbm')"
      ],
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "<style  type=\"text/css\" >\n",
              "    #T_a7834c00_dc2e_11ea_945e_0242ac1c0002row10_col0 {\n",
              "            background:  yellow;\n",
              "        }    #T_a7834c00_dc2e_11ea_945e_0242ac1c0002row10_col1 {\n",
              "            background:  yellow;\n",
              "        }    #T_a7834c00_dc2e_11ea_945e_0242ac1c0002row10_col2 {\n",
              "            background:  yellow;\n",
              "        }    #T_a7834c00_dc2e_11ea_945e_0242ac1c0002row10_col3 {\n",
              "            background:  yellow;\n",
              "        }    #T_a7834c00_dc2e_11ea_945e_0242ac1c0002row10_col4 {\n",
              "            background:  yellow;\n",
              "        }    #T_a7834c00_dc2e_11ea_945e_0242ac1c0002row10_col5 {\n",
              "            background:  yellow;\n",
              "        }</style><table id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >MAE</th>        <th class=\"col_heading level0 col1\" >MSE</th>        <th class=\"col_heading level0 col2\" >RMSE</th>        <th class=\"col_heading level0 col3\" >R2</th>        <th class=\"col_heading level0 col4\" >RMSLE</th>        <th class=\"col_heading level0 col5\" >MAPE</th>    </tr></thead><tbody>\n",
              "                <tr>\n",
              "                        <th id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row0_col0\" class=\"data row0 col0\" >762.6653</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row0_col1\" class=\"data row0 col1\" >3673803.8234</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row0_col2\" class=\"data row0 col2\" >1916.7169</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row0_col3\" class=\"data row0 col3\" >0.9701</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row0_col4\" class=\"data row0 col4\" >0.0728</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row0_col5\" class=\"data row0 col5\" >0.0523</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row1_col0\" class=\"data row1 col0\" >955.5267</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row1_col1\" class=\"data row1 col1\" >7425168.5522</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row1_col2\" class=\"data row1 col2\" >2724.9162</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row1_col3\" class=\"data row1 col3\" >0.9400</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row1_col4\" class=\"data row1 col4\" >0.0850</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row1_col5\" class=\"data row1 col5\" >0.0588</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row2_col0\" class=\"data row2 col0\" >852.9126</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row2_col1\" class=\"data row2 col1\" >5146188.1541</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row2_col2\" class=\"data row2 col2\" >2268.5211</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row2_col3\" class=\"data row2 col3\" >0.9579</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row2_col4\" class=\"data row2 col4\" >0.0834</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row2_col5\" class=\"data row2 col5\" >0.0610</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row3_col0\" class=\"data row3 col0\" >699.4826</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row3_col1\" class=\"data row3 col1\" >1730518.0345</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row3_col2\" class=\"data row3 col2\" >1315.4916</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row3_col3\" class=\"data row3 col3\" >0.9811</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row3_col4\" class=\"data row3 col4\" >0.0766</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row3_col5\" class=\"data row3 col5\" >0.0557</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row4_col0\" class=\"data row4 col0\" >633.4070</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row4_col1\" class=\"data row4 col1\" >1505126.5084</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row4_col2\" class=\"data row4 col2\" >1226.8360</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row4_col3\" class=\"data row4 col3\" >0.9852</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row4_col4\" class=\"data row4 col4\" >0.0681</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row4_col5\" class=\"data row4 col5\" >0.0523</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row5_col0\" class=\"data row5 col0\" >758.1128</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row5_col1\" class=\"data row5 col1\" >2698170.1978</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row5_col2\" class=\"data row5 col2\" >1642.6108</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row5_col3\" class=\"data row5 col3\" >0.9727</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row5_col4\" class=\"data row5 col4\" >0.0784</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row5_col5\" class=\"data row5 col5\" >0.0581</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row6_col0\" class=\"data row6 col0\" >846.1888</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row6_col1\" class=\"data row6 col1\" >6214502.5417</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row6_col2\" class=\"data row6 col2\" >2492.8904</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row6_col3\" class=\"data row6 col3\" >0.9395</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row6_col4\" class=\"data row6 col4\" >0.0811</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row6_col5\" class=\"data row6 col5\" >0.0582</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row7_col0\" class=\"data row7 col0\" >729.4342</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row7_col1\" class=\"data row7 col1\" >2328849.0908</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row7_col2\" class=\"data row7 col2\" >1526.0567</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row7_col3\" class=\"data row7 col3\" >0.9728</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row7_col4\" class=\"data row7 col4\" >0.0765</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row7_col5\" class=\"data row7 col5\" >0.0560</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row8_col0\" class=\"data row8 col0\" >837.5604</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row8_col1\" class=\"data row8 col1\" >2614949.9435</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row8_col2\" class=\"data row8 col2\" >1617.0807</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row8_col3\" class=\"data row8 col3\" >0.9738</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row8_col4\" class=\"data row8 col4\" >0.0824</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row8_col5\" class=\"data row8 col5\" >0.0622</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row9_col0\" class=\"data row9 col0\" >715.8950</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row9_col1\" class=\"data row9 col1\" >2427369.3891</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row9_col2\" class=\"data row9 col2\" >1558.0017</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row9_col3\" class=\"data row9 col3\" >0.9758</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row9_col4\" class=\"data row9 col4\" >0.0838</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row9_col5\" class=\"data row9 col5\" >0.0580</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002level0_row10\" class=\"row_heading level0 row10\" >Mean</th>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row10_col0\" class=\"data row10 col0\" >779.1185</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row10_col1\" class=\"data row10 col1\" >3576464.6236</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row10_col2\" class=\"data row10 col2\" >1828.9122</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row10_col3\" class=\"data row10 col3\" >0.9669</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row10_col4\" class=\"data row10 col4\" >0.0788</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row10_col5\" class=\"data row10 col5\" >0.0573</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002level0_row11\" class=\"row_heading level0 row11\" >SD</th>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row11_col0\" class=\"data row11 col0\" >89.0116</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row11_col1\" class=\"data row11 col1\" >1910918.8685</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row11_col2\" class=\"data row11 col2\" >481.1909</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row11_col3\" class=\"data row11 col3\" >0.0152</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row11_col4\" class=\"data row11 col4\" >0.0051</td>\n",
              "                        <td id=\"T_a7834c00_dc2e_11ea_945e_0242ac1c0002row11_col5\" class=\"data row11 col5\" >0.0031</td>\n",
              "            </tr>\n",
              "    </tbody></table>"
            ],
            "text/plain": [
              "<pandas.io.formats.style.Styler at 0x7fb25cdfceb8>"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab_type": "code",
        "id": "gmaIfnBMEQrE",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 292,
          "referenced_widgets": [
            "1de1da0d08c64148935f305cafdeaadc",
            "577eb34fbd6f4bdea66489337463c354",
            "f9312a23e9af43e183ebd777b133a2a9"
          ]
        },
        "outputId": "bc3b8389-0387-44d4-9fd9-6d71903e2230"
      },
      "source": [
        "tuned_lightgbm = tune_model(lightgbm)"
      ],
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "<style  type=\"text/css\" >\n",
              "    #T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row10_col0 {\n",
              "            background:  yellow;\n",
              "        }    #T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row10_col1 {\n",
              "            background:  yellow;\n",
              "        }    #T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row10_col2 {\n",
              "            background:  yellow;\n",
              "        }    #T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row10_col3 {\n",
              "            background:  yellow;\n",
              "        }    #T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row10_col4 {\n",
              "            background:  yellow;\n",
              "        }    #T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row10_col5 {\n",
              "            background:  yellow;\n",
              "        }</style><table id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >MAE</th>        <th class=\"col_heading level0 col1\" >MSE</th>        <th class=\"col_heading level0 col2\" >RMSE</th>        <th class=\"col_heading level0 col3\" >R2</th>        <th class=\"col_heading level0 col4\" >RMSLE</th>        <th class=\"col_heading level0 col5\" >MAPE</th>    </tr></thead><tbody>\n",
              "                <tr>\n",
              "                        <th id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row0_col0\" class=\"data row0 col0\" >823.0662</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row0_col1\" class=\"data row0 col1\" >2453046.6128</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row0_col2\" class=\"data row0 col2\" >1566.2205</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row0_col3\" class=\"data row0 col3\" >0.9801</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row0_col4\" class=\"data row0 col4\" >0.0865</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row0_col5\" class=\"data row0 col5\" >0.0632</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row1_col0\" class=\"data row1 col0\" >912.8832</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row1_col1\" class=\"data row1 col1\" >5993852.2732</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row1_col2\" class=\"data row1 col2\" >2448.2345</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row1_col3\" class=\"data row1 col3\" >0.9516</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row1_col4\" class=\"data row1 col4\" >0.0856</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row1_col5\" class=\"data row1 col5\" >0.0623</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row2_col0\" class=\"data row2 col0\" >832.1467</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row2_col1\" class=\"data row2 col1\" >3108349.3394</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row2_col2\" class=\"data row2 col2\" >1763.0511</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row2_col3\" class=\"data row2 col3\" >0.9745</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row2_col4\" class=\"data row2 col4\" >0.0862</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row2_col5\" class=\"data row2 col5\" >0.0651</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row3_col0\" class=\"data row3 col0\" >691.4328</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row3_col1\" class=\"data row3 col1\" >1452486.1837</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row3_col2\" class=\"data row3 col2\" >1205.1913</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row3_col3\" class=\"data row3 col3\" >0.9842</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row3_col4\" class=\"data row3 col4\" >0.0843</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row3_col5\" class=\"data row3 col5\" >0.0595</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row4_col0\" class=\"data row4 col0\" >722.3578</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row4_col1\" class=\"data row4 col1\" >1775038.5927</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row4_col2\" class=\"data row4 col2\" >1332.3057</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row4_col3\" class=\"data row4 col3\" >0.9826</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row4_col4\" class=\"data row4 col4\" >0.0805</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row4_col5\" class=\"data row4 col5\" >0.0599</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row5_col0\" class=\"data row5 col0\" >738.3989</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row5_col1\" class=\"data row5 col1\" >1958978.3936</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row5_col2\" class=\"data row5 col2\" >1399.6351</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row5_col3\" class=\"data row5 col3\" >0.9802</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row5_col4\" class=\"data row5 col4\" >0.0772</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row5_col5\" class=\"data row5 col5\" >0.0603</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row6_col0\" class=\"data row6 col0\" >843.2942</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row6_col1\" class=\"data row6 col1\" >5019902.1173</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row6_col2\" class=\"data row6 col2\" >2240.5138</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row6_col3\" class=\"data row6 col3\" >0.9511</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row6_col4\" class=\"data row6 col4\" >0.0860</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row6_col5\" class=\"data row6 col5\" >0.0625</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row7_col0\" class=\"data row7 col0\" >756.8554</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row7_col1\" class=\"data row7 col1\" >2315238.9726</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row7_col2\" class=\"data row7 col2\" >1521.5909</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row7_col3\" class=\"data row7 col3\" >0.9730</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row7_col4\" class=\"data row7 col4\" >0.0801</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row7_col5\" class=\"data row7 col5\" >0.0592</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row8_col0\" class=\"data row8 col0\" >837.2992</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row8_col1\" class=\"data row8 col1\" >2257821.7856</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row8_col2\" class=\"data row8 col2\" >1502.6050</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row8_col3\" class=\"data row8 col3\" >0.9774</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row8_col4\" class=\"data row8 col4\" >0.0835</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row8_col5\" class=\"data row8 col5\" >0.0642</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row9_col0\" class=\"data row9 col0\" >740.5726</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row9_col1\" class=\"data row9 col1\" >2154216.0963</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row9_col2\" class=\"data row9 col2\" >1467.7248</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row9_col3\" class=\"data row9 col3\" >0.9785</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row9_col4\" class=\"data row9 col4\" >0.0901</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row9_col5\" class=\"data row9 col5\" >0.0650</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002level0_row10\" class=\"row_heading level0 row10\" >Mean</th>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row10_col0\" class=\"data row10 col0\" >789.8307</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row10_col1\" class=\"data row10 col1\" >2848893.0367</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row10_col2\" class=\"data row10 col2\" >1644.7073</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row10_col3\" class=\"data row10 col3\" >0.9733</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row10_col4\" class=\"data row10 col4\" >0.0840</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row10_col5\" class=\"data row10 col5\" >0.0621</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002level0_row11\" class=\"row_heading level0 row11\" >SD</th>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row11_col0\" class=\"data row11 col0\" >65.9867</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row11_col1\" class=\"data row11 col1\" >1408540.1118</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row11_col2\" class=\"data row11 col2\" >379.2505</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row11_col3\" class=\"data row11 col3\" >0.0114</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row11_col4\" class=\"data row11 col4\" >0.0036</td>\n",
              "                        <td id=\"T_ab6e400e_dc2e_11ea_945e_0242ac1c0002row11_col5\" class=\"data row11 col5\" >0.0022</td>\n",
              "            </tr>\n",
              "    </tbody></table>"
            ],
            "text/plain": [
              "<pandas.io.formats.style.Styler at 0x7fb25cd07550>"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab_type": "code",
        "id": "nwaZk6oTEQsi",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 80
        },
        "outputId": "594ed7b7-0b2d-4a90-ab31-a0bace294024"
      },
      "source": [
        "predict_model(tuned_lightgbm );"
      ],
      "execution_count": 7,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Model</th>\n",
              "      <th>MAE</th>\n",
              "      <th>MSE</th>\n",
              "      <th>RMSE</th>\n",
              "      <th>R2</th>\n",
              "      <th>RMSLE</th>\n",
              "      <th>MAPE</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Light Gradient Boosting Machine</td>\n",
              "      <td>707.8043</td>\n",
              "      <td>1.828776e+06</td>\n",
              "      <td>1352.3223</td>\n",
              "      <td>0.9821</td>\n",
              "      <td>0.0776</td>\n",
              "      <td>0.0571</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                             Model       MAE  ...   RMSLE    MAPE\n",
              "0  Light Gradient Boosting Machine  707.8043  ...  0.0776  0.0571\n",
              "\n",
              "[1 rows x 7 columns]"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "colab_type": "text",
        "id": "r79BGjIfEQs1"
      },
      "source": [
        "# 12.0 Finalize Model for Deployment"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab_type": "code",
        "id": "_--tO4KGEQs-",
        "colab": {}
      },
      "source": [
        "final_lightgbm  = finalize_model(tuned_lightgbm )"
      ],
      "execution_count": 8,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab_type": "code",
        "id": "U9W6kXsSEQtQ",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 125
        },
        "outputId": "4bfc1789-f50e-4dc5-aa76-8ec80e7fe6b4"
      },
      "source": [
        "print(final_lightgbm)"
      ],
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "LGBMRegressor(boosting_type='gbdt', class_weight=None, colsample_bytree=1.0,\n",
            "              importance_type='split', learning_rate=0.4, max_depth=10,\n",
            "              min_child_samples=20, min_child_weight=0.001, min_split_gain=0.9,\n",
            "              n_estimators=90, n_jobs=-1, num_leaves=10, objective=None,\n",
            "              random_state=123, reg_alpha=0.9, reg_lambda=0.2, silent=True,\n",
            "              subsample=1.0, subsample_for_bin=200000, subsample_freq=0)\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab_type": "code",
        "id": "NJDk3I-EEQtg",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 80
        },
        "outputId": "18b12734-b0fb-4270-daca-c177d4dbb16c"
      },
      "source": [
        "predict_model(final_lightgbm);"
      ],
      "execution_count": 10,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Model</th>\n",
              "      <th>MAE</th>\n",
              "      <th>MSE</th>\n",
              "      <th>RMSE</th>\n",
              "      <th>R2</th>\n",
              "      <th>RMSLE</th>\n",
              "      <th>MAPE</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Light Gradient Boosting Machine</td>\n",
              "      <td>568.6295</td>\n",
              "      <td>880420.4651</td>\n",
              "      <td>938.3072</td>\n",
              "      <td>0.9914</td>\n",
              "      <td>0.0666</td>\n",
              "      <td>0.05</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                             Model       MAE          MSE  ...      R2   RMSLE  MAPE\n",
              "0  Light Gradient Boosting Machine  568.6295  880420.4651  ...  0.9914  0.0666  0.05\n",
              "\n",
              "[1 rows x 7 columns]"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "dWU2Dmdx2UNZ",
        "colab_type": "text"
      },
      "source": [
        "# 13.0 Deploy Model on Microsoft Azure\n",
        "\n",
        "This is the code to deploy model on Microsft azure using `pycaret` functionalities."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "PtdFIPJJ0zHX",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 485
        },
        "outputId": "58dee8d4-02f9-4018-c3ba-3dd3209628ff"
      },
      "source": [
        "# ! pip install azure-storage-blob\n",
        "! pip install awscli\n",
        "\n"
      ],
      "execution_count": 11,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Collecting awscli\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/db/87/d390c07c9f761c682b71d0c5e99fe46193b91e6140a4dde04044c70fdeb6/awscli-1.18.117-py2.py3-none-any.whl (3.3MB)\n",
            "\u001b[K     |████████████████████████████████| 3.3MB 8.3MB/s \n",
            "\u001b[?25hCollecting botocore==1.17.40\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/3d/77/4f1f409c9c454ae798cff20744efacd5ca79059159272857636b6b560bf6/botocore-1.17.40-py2.py3-none-any.whl (6.5MB)\n",
            "\u001b[K     |████████████████████████████████| 6.5MB 45.2MB/s \n",
            "\u001b[?25hCollecting rsa<=4.5.0,>=3.1.2; python_version != \"3.4\"\n",
            "  Downloading https://files.pythonhosted.org/packages/26/f8/8127fdda0294f044121d20aac7785feb810e159098447967a6103dedfb96/rsa-4.5-py2.py3-none-any.whl\n",
            "Requirement already satisfied: s3transfer<0.4.0,>=0.3.0 in /usr/local/lib/python3.6/dist-packages (from awscli) (0.3.3)\n",
            "Requirement already satisfied: PyYAML<5.4,>=3.10; python_version != \"3.4\" in /usr/local/lib/python3.6/dist-packages (from awscli) (3.13)\n",
            "Requirement already satisfied: docutils<0.16,>=0.10 in /usr/local/lib/python3.6/dist-packages (from awscli) (0.15.2)\n",
            "Collecting colorama<0.4.4,>=0.2.5; python_version != \"3.4\"\n",
            "  Downloading https://files.pythonhosted.org/packages/c9/dc/45cdef1b4d119eb96316b3117e6d5708a08029992b2fee2c143c7a0a5cc5/colorama-0.4.3-py2.py3-none-any.whl\n",
            "Requirement already satisfied: urllib3<1.26,>=1.20; python_version != \"3.4\" in /usr/local/lib/python3.6/dist-packages (from botocore==1.17.40->awscli) (1.24.3)\n",
            "Requirement already satisfied: jmespath<1.0.0,>=0.7.1 in /usr/local/lib/python3.6/dist-packages (from botocore==1.17.40->awscli) (0.10.0)\n",
            "Requirement already satisfied: python-dateutil<3.0.0,>=2.1 in /usr/local/lib/python3.6/dist-packages (from botocore==1.17.40->awscli) (2.8.1)\n",
            "Requirement already satisfied: pyasn1>=0.1.3 in /usr/local/lib/python3.6/dist-packages (from rsa<=4.5.0,>=3.1.2; python_version != \"3.4\"->awscli) (0.4.8)\n",
            "Requirement already satisfied: six>=1.5 in /usr/local/lib/python3.6/dist-packages (from python-dateutil<3.0.0,>=2.1->botocore==1.17.40->awscli) (1.15.0)\n",
            "Installing collected packages: botocore, rsa, colorama, awscli\n",
            "  Found existing installation: botocore 1.17.37\n",
            "    Uninstalling botocore-1.17.37:\n",
            "      Successfully uninstalled botocore-1.17.37\n",
            "  Found existing installation: rsa 4.6\n",
            "    Uninstalling rsa-4.6:\n",
            "      Successfully uninstalled rsa-4.6\n",
            "Successfully installed awscli-1.18.117 botocore-1.17.40 colorama-0.4.3 rsa-4.5\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ImFnwpb52iDl",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "## Enter connection string when running in google colab\n",
        "connect_str = '' #@param {type:\"string\"}\n",
        "print(connect_str)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "4FolddlO2iTK",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "#! export AZURE_STORAGE_CONNECTION_STRING=connect_str"
      ],
      "execution_count": 13,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "q_MZPZ4271g3",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import os\n",
        "os.environ['AZURE_STORAGE_CONNECTION_STRING']= connect_str"
      ],
      "execution_count": 14,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "wz0YIfLb6iVK",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "! echo $AZURE_STORAGE_CONNECTION_STRING"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "cUOqSvi63m01",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "os.getenv('AZURE_STORAGE_CONNECTION_STRING')"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "H3C-nMpF2iZg",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "authentication = {'container': 'pycaret-reg-1011'}\n",
        "model_name = 'lightgbm-reg-101'\n",
        "deploy_model(final_lightgbm, model_name, authentication, platform = 'azure')"
      ],
      "execution_count": 17,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "iuBz98UT2icD",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 107
        },
        "outputId": "946b34d4-aadf-470b-bac5-5fd49d8f2198"
      },
      "source": [
        "authentication = {'container': 'pycaret-reg-1011'}\n",
        "model_name = 'lightgbm-reg-101'\n",
        "model_azure = load_model(model_name, \n",
        "               platform = 'azure', \n",
        "               authentication = authentication,\n",
        "               verbose=True)"
      ],
      "execution_count": 18,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Loading model from Microsoft Azure\n",
            "\n",
            "Downloading blob to \n",
            "\tlightgbm-reg-101.pkl\n",
            "Transformation Pipeline and Model Successfully Loaded\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "aiP_EiLm2iWk",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "\n",
        "unseen_predictions = predict_model(model_azure, data=data_unseen, verbose=True)"
      ],
      "execution_count": 19,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "G9s2LdGIbIlV",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 519
        },
        "outputId": "1a3ce935-f82c-40ff-b7f9-1fb816e7e090"
      },
      "source": [
        "predict_model(model_azure)"
      ],
      "execution_count": 20,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Model</th>\n",
              "      <th>MAE</th>\n",
              "      <th>MSE</th>\n",
              "      <th>RMSE</th>\n",
              "      <th>R2</th>\n",
              "      <th>RMSLE</th>\n",
              "      <th>MAPE</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Light Gradient Boosting Machine</td>\n",
              "      <td>568.6295</td>\n",
              "      <td>880420.4651</td>\n",
              "      <td>938.3072</td>\n",
              "      <td>0.9914</td>\n",
              "      <td>0.0666</td>\n",
              "      <td>0.05</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                             Model       MAE          MSE  ...      R2   RMSLE  MAPE\n",
              "0  Light Gradient Boosting Machine  568.6295  880420.4651  ...  0.9914  0.0666  0.05\n",
              "\n",
              "[1 rows x 7 columns]"
            ]
          },
          "metadata": {
            "tags": []
          }
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Carat Weight</th>\n",
              "      <th>Cut_Fair</th>\n",
              "      <th>Cut_Good</th>\n",
              "      <th>Cut_Ideal</th>\n",
              "      <th>Cut_Signature-Ideal</th>\n",
              "      <th>Cut_Very Good</th>\n",
              "      <th>Color_D</th>\n",
              "      <th>Color_E</th>\n",
              "      <th>Color_F</th>\n",
              "      <th>Color_G</th>\n",
              "      <th>Color_H</th>\n",
              "      <th>Color_I</th>\n",
              "      <th>Clarity_FL</th>\n",
              "      <th>Clarity_IF</th>\n",
              "      <th>Clarity_SI1</th>\n",
              "      <th>Clarity_VS1</th>\n",
              "      <th>Clarity_VS2</th>\n",
              "      <th>Clarity_VVS1</th>\n",
              "      <th>Clarity_VVS2</th>\n",
              "      <th>Polish_EX</th>\n",
              "      <th>Polish_G</th>\n",
              "      <th>Polish_ID</th>\n",
              "      <th>Polish_VG</th>\n",
              "      <th>Symmetry_EX</th>\n",
              "      <th>Symmetry_G</th>\n",
              "      <th>Symmetry_ID</th>\n",
              "      <th>Symmetry_VG</th>\n",
              "      <th>Report_AGSL</th>\n",
              "      <th>Report_GIA</th>\n",
              "      <th>Price</th>\n",
              "      <th>Label</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1.60</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>12942</td>\n",
              "      <td>13087.2057</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1.15</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>6110</td>\n",
              "      <td>6159.4249</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2.37</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>28063</td>\n",
              "      <td>26176.5884</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2.01</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>25948</td>\n",
              "      <td>24200.7832</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>0.91</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>4381</td>\n",
              "      <td>4480.3517</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1706</th>\n",
              "      <td>0.90</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>7268</td>\n",
              "      <td>6947.5704</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1707</th>\n",
              "      <td>1.02</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>6622</td>\n",
              "      <td>6908.6135</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1708</th>\n",
              "      <td>1.54</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>12120</td>\n",
              "      <td>12003.2709</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1709</th>\n",
              "      <td>0.91</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>6682</td>\n",
              "      <td>6807.2423</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1710</th>\n",
              "      <td>2.02</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>15785</td>\n",
              "      <td>15616.2373</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1711 rows × 31 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "      Carat Weight  Cut_Fair  Cut_Good  ...  Report_GIA  Price       Label\n",
              "0             1.60       0.0       0.0  ...         0.0  12942  13087.2057\n",
              "1             1.15       0.0       0.0  ...         0.0   6110   6159.4249\n",
              "2             2.37       0.0       0.0  ...         1.0  28063  26176.5884\n",
              "3             2.01       0.0       0.0  ...         1.0  25948  24200.7832\n",
              "4             0.91       0.0       0.0  ...         1.0   4381   4480.3517\n",
              "...            ...       ...       ...  ...         ...    ...         ...\n",
              "1706          0.90       0.0       0.0  ...         1.0   7268   6947.5704\n",
              "1707          1.02       0.0       0.0  ...         1.0   6622   6908.6135\n",
              "1708          1.54       0.0       0.0  ...         0.0  12120  12003.2709\n",
              "1709          0.91       0.0       0.0  ...         1.0   6682   6807.2423\n",
              "1710          2.02       0.0       0.0  ...         1.0  15785  15616.2373\n",
              "\n",
              "[1711 rows x 31 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 20
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "UkX3mtAD2iJH",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 419
        },
        "outputId": "a23a5132-24e3-4a65-81cf-8f791e4b57a0"
      },
      "source": [
        "unseen_predictions"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Carat Weight</th>\n",
              "      <th>Cut</th>\n",
              "      <th>Color</th>\n",
              "      <th>Clarity</th>\n",
              "      <th>Polish</th>\n",
              "      <th>Symmetry</th>\n",
              "      <th>Report</th>\n",
              "      <th>Price</th>\n",
              "      <th>Label</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1.23</td>\n",
              "      <td>Very Good</td>\n",
              "      <td>G</td>\n",
              "      <td>VS1</td>\n",
              "      <td>EX</td>\n",
              "      <td>EX</td>\n",
              "      <td>GIA</td>\n",
              "      <td>8445</td>\n",
              "      <td>9072.6351</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>0.90</td>\n",
              "      <td>Fair</td>\n",
              "      <td>I</td>\n",
              "      <td>VS1</td>\n",
              "      <td>VG</td>\n",
              "      <td>EX</td>\n",
              "      <td>GIA</td>\n",
              "      <td>3526</td>\n",
              "      <td>3554.2894</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>0.77</td>\n",
              "      <td>Very Good</td>\n",
              "      <td>G</td>\n",
              "      <td>VVS1</td>\n",
              "      <td>EX</td>\n",
              "      <td>ID</td>\n",
              "      <td>AGSL</td>\n",
              "      <td>3966</td>\n",
              "      <td>4229.3503</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1.51</td>\n",
              "      <td>Very Good</td>\n",
              "      <td>D</td>\n",
              "      <td>VS2</td>\n",
              "      <td>EX</td>\n",
              "      <td>EX</td>\n",
              "      <td>GIA</td>\n",
              "      <td>14416</td>\n",
              "      <td>14623.5531</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2.33</td>\n",
              "      <td>Ideal</td>\n",
              "      <td>H</td>\n",
              "      <td>SI1</td>\n",
              "      <td>ID</td>\n",
              "      <td>ID</td>\n",
              "      <td>AGSL</td>\n",
              "      <td>21618</td>\n",
              "      <td>20527.9639</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>295</th>\n",
              "      <td>1.03</td>\n",
              "      <td>Ideal</td>\n",
              "      <td>D</td>\n",
              "      <td>SI1</td>\n",
              "      <td>EX</td>\n",
              "      <td>EX</td>\n",
              "      <td>GIA</td>\n",
              "      <td>6250</td>\n",
              "      <td>6742.9309</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>296</th>\n",
              "      <td>1.00</td>\n",
              "      <td>Very Good</td>\n",
              "      <td>D</td>\n",
              "      <td>SI1</td>\n",
              "      <td>VG</td>\n",
              "      <td>VG</td>\n",
              "      <td>GIA</td>\n",
              "      <td>5328</td>\n",
              "      <td>5621.3273</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>297</th>\n",
              "      <td>1.02</td>\n",
              "      <td>Ideal</td>\n",
              "      <td>D</td>\n",
              "      <td>SI1</td>\n",
              "      <td>EX</td>\n",
              "      <td>EX</td>\n",
              "      <td>GIA</td>\n",
              "      <td>6157</td>\n",
              "      <td>6679.0715</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>298</th>\n",
              "      <td>1.27</td>\n",
              "      <td>Signature-Ideal</td>\n",
              "      <td>G</td>\n",
              "      <td>VS1</td>\n",
              "      <td>EX</td>\n",
              "      <td>EX</td>\n",
              "      <td>GIA</td>\n",
              "      <td>11206</td>\n",
              "      <td>11642.7346</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>299</th>\n",
              "      <td>2.19</td>\n",
              "      <td>Ideal</td>\n",
              "      <td>E</td>\n",
              "      <td>VS1</td>\n",
              "      <td>EX</td>\n",
              "      <td>EX</td>\n",
              "      <td>GIA</td>\n",
              "      <td>30507</td>\n",
              "      <td>35164.7663</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>300 rows × 9 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "     Carat Weight              Cut Color  ... Report  Price       Label\n",
              "0            1.23        Very Good     G  ...    GIA   8445   9072.6351\n",
              "1            0.90             Fair     I  ...    GIA   3526   3554.2894\n",
              "2            0.77        Very Good     G  ...   AGSL   3966   4229.3503\n",
              "3            1.51        Very Good     D  ...    GIA  14416  14623.5531\n",
              "4            2.33            Ideal     H  ...   AGSL  21618  20527.9639\n",
              "..            ...              ...   ...  ...    ...    ...         ...\n",
              "295          1.03            Ideal     D  ...    GIA   6250   6742.9309\n",
              "296          1.00        Very Good     D  ...    GIA   5328   5621.3273\n",
              "297          1.02            Ideal     D  ...    GIA   6157   6679.0715\n",
              "298          1.27  Signature-Ideal     G  ...    GIA  11206  11642.7346\n",
              "299          2.19            Ideal     E  ...    GIA  30507  35164.7663\n",
              "\n",
              "[300 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 24
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "2CRqugcz2h5a",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "0ZxYxszDBqJh",
        "colab_type": "text"
      },
      "source": [
        "# 13.0 Deploy Model on Google Cloud"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "N5qy_gsfB1rA",
        "colab_type": "text"
      },
      "source": [
        "After the model is finalised and you are happy with the model, you can deploy the model on your cloud of choice. In this section, we deploy the model on the google cloud platform. "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "2eJdBC3EClnW",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "from google.colab import auth\n",
        "auth.authenticate_user()"
      ],
      "execution_count": 21,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "9L31JPblEPG6",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "! pip install awscli"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "i8xWrcliQCz1",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 35
        },
        "outputId": "77c554fd-d401-4186-c755-741465ba1806"
      },
      "source": [
        "# GCP project name, Change the name based on your own GCP project.\n",
        "CLOUD_PROJECT = 'gcpessentials-rz' # GCP project name\n",
        "bucket_name = 'pycaret-reg101-test1' # bucket name for storage of your model\n",
        "BUCKET = 'gs://' + CLOUD_PROJECT + '-{}'.format(bucket_name)\n",
        "# Set the gcloud consol to $CLOUD_PROJECT Environment Variable for your Desired Project)\n",
        "!gcloud config set project $CLOUD_PROJECT"
      ],
      "execution_count": 22,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Updated property [core/project].\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "fq7-Su1iQuHl",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "authentication = {'project': CLOUD_PROJECT, 'bucket' : bucket_name}\n",
        "model_name = 'lightgbm-reg'\n",
        "deploy_model(final_lightgbm, model_name, authentication, platform = 'gcp')"
      ],
      "execution_count": 23,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "CN0CkUXKRAlc",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 53
        },
        "outputId": "9abf26f2-377f-4327-89af-07ffbab14bc5"
      },
      "source": [
        "authentication = {'project': CLOUD_PROJECT, 'bucket' : bucket_name}\n",
        "model_name = 'lightgbm-reg'\n",
        "model_gcp = load_model(model_name, \n",
        "               platform = 'gcp', \n",
        "               authentication = authentication,\n",
        "               verbose=True)"
      ],
      "execution_count": 24,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "loading model from GCP\n",
            "Transformation Pipeline and Model Successfully Loaded\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "bIMlREBHXTtF",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "\n",
        "unseen_predictions = predict_model(model_gcp, data=data_unseen, verbose=True)"
      ],
      "execution_count": 25,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "CFxn0KJ_ebGz",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 419
        },
        "outputId": "cffebb43-47cb-4482-fb6d-777d65ac1e5d"
      },
      "source": [
        "unseen_predictions"
      ],
      "execution_count": 26,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Carat Weight</th>\n",
              "      <th>Cut</th>\n",
              "      <th>Color</th>\n",
              "      <th>Clarity</th>\n",
              "      <th>Polish</th>\n",
              "      <th>Symmetry</th>\n",
              "      <th>Report</th>\n",
              "      <th>Price</th>\n",
              "      <th>Label</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1.23</td>\n",
              "      <td>Very Good</td>\n",
              "      <td>G</td>\n",
              "      <td>VS1</td>\n",
              "      <td>EX</td>\n",
              "      <td>EX</td>\n",
              "      <td>GIA</td>\n",
              "      <td>8445</td>\n",
              "      <td>9072.6351</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>0.90</td>\n",
              "      <td>Fair</td>\n",
              "      <td>I</td>\n",
              "      <td>VS1</td>\n",
              "      <td>VG</td>\n",
              "      <td>EX</td>\n",
              "      <td>GIA</td>\n",
              "      <td>3526</td>\n",
              "      <td>3554.2894</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>0.77</td>\n",
              "      <td>Very Good</td>\n",
              "      <td>G</td>\n",
              "      <td>VVS1</td>\n",
              "      <td>EX</td>\n",
              "      <td>ID</td>\n",
              "      <td>AGSL</td>\n",
              "      <td>3966</td>\n",
              "      <td>4229.3503</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1.51</td>\n",
              "      <td>Very Good</td>\n",
              "      <td>D</td>\n",
              "      <td>VS2</td>\n",
              "      <td>EX</td>\n",
              "      <td>EX</td>\n",
              "      <td>GIA</td>\n",
              "      <td>14416</td>\n",
              "      <td>14623.5531</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2.33</td>\n",
              "      <td>Ideal</td>\n",
              "      <td>H</td>\n",
              "      <td>SI1</td>\n",
              "      <td>ID</td>\n",
              "      <td>ID</td>\n",
              "      <td>AGSL</td>\n",
              "      <td>21618</td>\n",
              "      <td>20527.9639</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>295</th>\n",
              "      <td>1.03</td>\n",
              "      <td>Ideal</td>\n",
              "      <td>D</td>\n",
              "      <td>SI1</td>\n",
              "      <td>EX</td>\n",
              "      <td>EX</td>\n",
              "      <td>GIA</td>\n",
              "      <td>6250</td>\n",
              "      <td>6742.9309</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>296</th>\n",
              "      <td>1.00</td>\n",
              "      <td>Very Good</td>\n",
              "      <td>D</td>\n",
              "      <td>SI1</td>\n",
              "      <td>VG</td>\n",
              "      <td>VG</td>\n",
              "      <td>GIA</td>\n",
              "      <td>5328</td>\n",
              "      <td>5621.3273</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>297</th>\n",
              "      <td>1.02</td>\n",
              "      <td>Ideal</td>\n",
              "      <td>D</td>\n",
              "      <td>SI1</td>\n",
              "      <td>EX</td>\n",
              "      <td>EX</td>\n",
              "      <td>GIA</td>\n",
              "      <td>6157</td>\n",
              "      <td>6679.0715</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>298</th>\n",
              "      <td>1.27</td>\n",
              "      <td>Signature-Ideal</td>\n",
              "      <td>G</td>\n",
              "      <td>VS1</td>\n",
              "      <td>EX</td>\n",
              "      <td>EX</td>\n",
              "      <td>GIA</td>\n",
              "      <td>11206</td>\n",
              "      <td>11642.7346</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>299</th>\n",
              "      <td>2.19</td>\n",
              "      <td>Ideal</td>\n",
              "      <td>E</td>\n",
              "      <td>VS1</td>\n",
              "      <td>EX</td>\n",
              "      <td>EX</td>\n",
              "      <td>GIA</td>\n",
              "      <td>30507</td>\n",
              "      <td>35164.7663</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>300 rows × 9 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "     Carat Weight              Cut Color  ... Report  Price       Label\n",
              "0            1.23        Very Good     G  ...    GIA   8445   9072.6351\n",
              "1            0.90             Fair     I  ...    GIA   3526   3554.2894\n",
              "2            0.77        Very Good     G  ...   AGSL   3966   4229.3503\n",
              "3            1.51        Very Good     D  ...    GIA  14416  14623.5531\n",
              "4            2.33            Ideal     H  ...   AGSL  21618  20527.9639\n",
              "..            ...              ...   ...  ...    ...    ...         ...\n",
              "295          1.03            Ideal     D  ...    GIA   6250   6742.9309\n",
              "296          1.00        Very Good     D  ...    GIA   5328   5621.3273\n",
              "297          1.02            Ideal     D  ...    GIA   6157   6679.0715\n",
              "298          1.27  Signature-Ideal     G  ...    GIA  11206  11642.7346\n",
              "299          2.19            Ideal     E  ...    GIA  30507  35164.7663\n",
              "\n",
              "[300 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 26
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "tzpXE4Jmbull",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    }
  ]
}